Pivot Table keeps doubling same data?

H

Harbor1704

New Member
Joined
Feb 11, 2021
Messages
11
Office Version
  1. 365
Platform
  1. Windows
Good day,
I have a workbook where I add monthly numbers into a data sheet and the the pivot table updates. I added the new data to the existing data and when I update the Pivot table it takes the new data and doubles the range. So I have the range duplicated when it should all be in one. I know it is confusing. It is confusing me. I have tried to re-do the pivot table and it is still doing it so I am at a loss. Please see below, the mini sheet with the way it should look, the data sheet, and the way it keeps showing up. I have not included all the data as it would be 6K rows.

The way it should look:

2022 Independent Agent TURN TIMES (004) WORKING COPY.xlsx
ABCDEFGHIJKL
1SearcherName(All)
2Month AugAug
3CountOn Time %Late %
4Count of File NumberRange
5CustomerName1 Day2 Days 3 -4 DaysOver 4 DaysGrand Total1 Day2 DaysTotal On Time3 - 4 DaysOver 4 DaysTotal Late
6ADAM M. BROUILLARD, ATTORNEY AT LAW (2867)2130%67%67%33%0%33%
7AMERICAN GUARDIAN TITLE USA, INC. (2795)11100%0%100%0%0%0%
8AMERICAN TITLE TRUST LLC (2610)11100%0%100%0%0%0%
9AXIS TITLE, LLC (2501)33100%0%100%0%0%0%
10BAILLIE & HERSHMAN, P.C. (795)1560%0%0%17%83%100%
11CAPE CORAL TITLE INSURANCE, INC. (2866)21367%0%67%0%33%33%
12CLOSING BEAR, LLC (2773)11100%0%100%0%0%0%
13DHI TITLE OF FLORIDA, INC.1111292%8%100%0%0%0%
14ENTERPRISE TITLE, INC. (2355)110%100%100%0%0%0%
Summary-2022 YTD
Cell Formulas
RangeFormula
G6:H14G6=B6/$F6
I6:I14,L6:L14I6=G6+H6
J6:K14J6=D6/$F6
Cells with Conditional Formatting
CellConditionCell FormatStop If True
I6:I34,I39:I86Cell Value>0.7449textNO


The Data Sheet:
2022 Independent Agent TURN TIMES (004) WORKING COPY.xlsx
ABCDEFGHIJ
1CustomerNameSearcherNameActivityStartFinish DateProduction TimeMonthRangeOn Time/LateFile Number
2TITLE PARTNERS & ASSOCIATES (2784)IAN RIVERAFile Completed and sentAug 5, 2022Aug 5, 2022 4 hour(s) 6 min.Aug1 DayOn Time2784.22-0806
3LANDSEL TITLE AGENCY, INC. (2623)JOSEPH AVILESFile Completed and sentAug 5, 2022Aug 5, 2022 3 hour(s) 7 min.Aug1 DayOn Time2623.FL-3201
4HAYWARD TITLE GROUP (2483)ENID HURSTFile Completed and sentAug 5, 2022Aug 5, 2022 2 hour(s) 58 min.Aug1 DayOn Time2483.22C-0507
5LANDSEL TITLE AGENCY, INC. (2623)JUSTIN STEWARTFile Completed and sentAug 4, 2022Aug 5, 20221 day(s) 2 hour(s) 18 min.Aug2 Days On Time2623.MC-2305
6HAYWARD TITLE GROUP (2483)JOY BATISEFile Completed and sentAug 4, 2022Aug 5, 2022 6 hour(s) 6 min.Aug1 DayOn Time2483.22C-0503
7LANDSEL TITLE AGENCY, INC. (2623)JOEL MCMANAMEYFile Completed and sentAug 5, 2022Aug 5, 2022 1 hour(s) Aug1 DayOn Time2623.FL-3200
8CAPE CORAL TITLE INSURANCE, INC. (2866)ENID HURSTFile Completed and sentAug 5, 2022Aug 5, 2022 2 hour(s) 41 min.Aug1 DayOn Time2866.75798
9THE LAW OFFICES OF JUSTIN RICKMAN (2679)DENISE BLAIRFile Completed and sentAug 4, 2022Aug 5, 20221 day(s) 2 hour(s) 2 min.Aug2 Days On Time2679.342-22
10HAYWARD TITLE GROUP (2483)MARGARET PATCHETTFile Completed and sentAug 5, 2022Aug 5, 2022 1 hour(s) 5 min.Aug1 DayOn Time2483.22C-0506
11LANDSEL TITLE AGENCY, INC. (2623)RICK BROWNFile Completed and sentAug 5, 2022Aug 5, 2022 2 hour(s) 6 min.Aug1 DayOn Time2623.SF-10081
12NORTH SOUTH EAST, LLC dba MAGNOLIA CLOSING COMPANY (2601)IAN RIVERAFile Completed and sentAug 5, 2022Aug 5, 2022 1 hour(s) 19 min.Aug1 DayOn Time2601.12210443
Data


What it is showing as after refresh:
2022 Independent Agent TURN TIMES (004) WORKING COPY.xlsx
ABCDEFGHIJKL
1SearcherName(All)
2Month Aug(All)
3CountOn Time %Late %
4Count of File NumberRange
5CustomerName1 Day2 Days 3 -4 DaysOver 4 Days1 Day Grand Total2 DaysTotal On Time3 - 4 DaysOver 4 DaysTotal Late
6ADAM M. BROUILLARD, ATTORNEY AT LAW (2867)213#DIV/0!#DIV/0!######DIV/0!#DIV/0!
7ALLIED TITLE GROUP, LLC (2611)125264%2604%0%0%0%
8ALOMA TITLE COMPANY (1107)16717%717%0%0%0%
9ALOMA TITLE COMPANY (1113)143405735%5735%8%0%8%
10AMERICAN GUARDIAN TITLE USA, INC. (2795)241723688114%8914%19%6%25%
11AMERICAN TITLE TRUST LLC (2610)1571371%1371%0%0%0%
12ASSURE AMERICA TITLE COMPANY (364)1212203560%3560%5%10%15%
13AXIS TITLE, LLC (2501)31675366744%6744%19%14%33%
14A-Z TEAM TITLE, LLC (1072)3641979618967%18967%20%7%27%
15BAILLIE & HERSHMAN, P.C. (795)21113#DIV/0!#DIV/0!######DIV/0!#DIV/0!
16BAND, GATES & DRAMIS, P.L. (2621)2453488050%8050%10%6%17%
17BERLING PATTEN EBLING, PLLC (2874)110%100%0%0%0%
18BOGIN MUNNS & MUNNS (2789)115720%720%20%0%20%
Summary-2022 YTD
Cell Formulas
RangeFormula
H6:H18H6=C6/$F6
I6:I18,L6:L18I6=G6+H6
J6:K18J6=D6/$F6
Cells with Conditional Formatting
CellConditionCell FormatStop If True
I6:I34,I39:I86Cell Value>0.7449textNO
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
You must log in or register to reply here.

Similar threads

S
  • Solved
Rotating Data from Horizontal to Vertical using VBA Code
Replies
3
Views
390
kevin9999
K
P
  • Solved
Lookup based on multiple criteria
2 3
Replies
22
Views
934
paulkc
P
M
  • Question Question
Help with FilterXML formula
Replies
0
Views
2K
montex01
M
PS_Richard
  • Solved
Calculate Time Difference Per Day Based On Criteria
Replies
5
Views
772
Anthony47
A
F
  • Solved
Filter leaves last row of data visible regardless of what is filtered
Replies
2
Views
748
frank_AL
F

Forum statistics

Threads
1,224,820
Messages
6,181,159
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top