Harbor1704
New Member
- Joined
- Feb 11, 2021
- Messages
- 11
- Office Version
- 365
- Platform
- 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:
The Data Sheet:
What it is showing as after refresh:
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 | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | SearcherName | (All) | ||||||||||||
| 2 | Month Aug | Aug | ||||||||||||
| 3 | Count | On Time % | Late % | |||||||||||
| 4 | Count of File Number | Range | ||||||||||||
| 5 | CustomerName | 1 Day | 2 Days | 3 -4 Days | Over 4 Days | Grand Total | 1 Day | 2 Days | Total On Time | 3 - 4 Days | Over 4 Days | Total Late | ||
| 6 | ADAM M. BROUILLARD, ATTORNEY AT LAW (2867) | 2 | 1 | 3 | 0% | 67% | 67% | 33% | 0% | 33% | ||||
| 7 | AMERICAN GUARDIAN TITLE USA, INC. (2795) | 1 | 1 | 100% | 0% | 100% | 0% | 0% | 0% | |||||
| 8 | AMERICAN TITLE TRUST LLC (2610) | 1 | 1 | 100% | 0% | 100% | 0% | 0% | 0% | |||||
| 9 | AXIS TITLE, LLC (2501) | 3 | 3 | 100% | 0% | 100% | 0% | 0% | 0% | |||||
| 10 | BAILLIE & HERSHMAN, P.C. (795) | 1 | 5 | 6 | 0% | 0% | 0% | 17% | 83% | 100% | ||||
| 11 | CAPE CORAL TITLE INSURANCE, INC. (2866) | 2 | 1 | 3 | 67% | 0% | 67% | 0% | 33% | 33% | ||||
| 12 | CLOSING BEAR, LLC (2773) | 1 | 1 | 100% | 0% | 100% | 0% | 0% | 0% | |||||
| 13 | DHI TITLE OF FLORIDA, INC. | 11 | 1 | 12 | 92% | 8% | 100% | 0% | 0% | 0% | ||||
| 14 | ENTERPRISE TITLE, INC. (2355) | 1 | 1 | 0% | 100% | 100% | 0% | 0% | 0% | |||||
Summary-2022 YTD | ||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G6:H14 | G6 | =B6/$F6 |
| I6:I14,L6:L14 | I6 | =G6+H6 |
| J6:K14 | J6 | =D6/$F6 |
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| I6:I34,I39:I86 | Cell Value | >0.7449 | text | NO |
The Data Sheet:
| 2022 Independent Agent TURN TIMES (004) WORKING COPY.xlsx | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | |||
| 1 | CustomerName | SearcherName | Activity | Start | Finish Date | Production Time | Month | Range | On Time/Late | File Number | ||
| 2 | TITLE PARTNERS & ASSOCIATES (2784) | IAN RIVERA | File Completed and sent | Aug 5, 2022 | Aug 5, 2022 | 4 hour(s) 6 min. | Aug | 1 Day | On Time | 2784.22-0806 | ||
| 3 | LANDSEL TITLE AGENCY, INC. (2623) | JOSEPH AVILES | File Completed and sent | Aug 5, 2022 | Aug 5, 2022 | 3 hour(s) 7 min. | Aug | 1 Day | On Time | 2623.FL-3201 | ||
| 4 | HAYWARD TITLE GROUP (2483) | ENID HURST | File Completed and sent | Aug 5, 2022 | Aug 5, 2022 | 2 hour(s) 58 min. | Aug | 1 Day | On Time | 2483.22C-0507 | ||
| 5 | LANDSEL TITLE AGENCY, INC. (2623) | JUSTIN STEWART | File Completed and sent | Aug 4, 2022 | Aug 5, 2022 | 1 day(s) 2 hour(s) 18 min. | Aug | 2 Days | On Time | 2623.MC-2305 | ||
| 6 | HAYWARD TITLE GROUP (2483) | JOY BATISE | File Completed and sent | Aug 4, 2022 | Aug 5, 2022 | 6 hour(s) 6 min. | Aug | 1 Day | On Time | 2483.22C-0503 | ||
| 7 | LANDSEL TITLE AGENCY, INC. (2623) | JOEL MCMANAMEY | File Completed and sent | Aug 5, 2022 | Aug 5, 2022 | 1 hour(s) | Aug | 1 Day | On Time | 2623.FL-3200 | ||
| 8 | CAPE CORAL TITLE INSURANCE, INC. (2866) | ENID HURST | File Completed and sent | Aug 5, 2022 | Aug 5, 2022 | 2 hour(s) 41 min. | Aug | 1 Day | On Time | 2866.75798 | ||
| 9 | THE LAW OFFICES OF JUSTIN RICKMAN (2679) | DENISE BLAIR | File Completed and sent | Aug 4, 2022 | Aug 5, 2022 | 1 day(s) 2 hour(s) 2 min. | Aug | 2 Days | On Time | 2679.342-22 | ||
| 10 | HAYWARD TITLE GROUP (2483) | MARGARET PATCHETT | File Completed and sent | Aug 5, 2022 | Aug 5, 2022 | 1 hour(s) 5 min. | Aug | 1 Day | On Time | 2483.22C-0506 | ||
| 11 | LANDSEL TITLE AGENCY, INC. (2623) | RICK BROWN | File Completed and sent | Aug 5, 2022 | Aug 5, 2022 | 2 hour(s) 6 min. | Aug | 1 Day | On Time | 2623.SF-10081 | ||
| 12 | NORTH SOUTH EAST, LLC dba MAGNOLIA CLOSING COMPANY (2601) | IAN RIVERA | File Completed and sent | Aug 5, 2022 | Aug 5, 2022 | 1 hour(s) 19 min. | Aug | 1 Day | On Time | 2601.12210443 | ||
Data | ||||||||||||
What it is showing as after refresh:
| 2022 Independent Agent TURN TIMES (004) WORKING COPY.xlsx | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | SearcherName | (All) | ||||||||||||
| 2 | Month Aug | (All) | ||||||||||||
| 3 | Count | On Time % | Late % | |||||||||||
| 4 | Count of File Number | Range | ||||||||||||
| 5 | CustomerName | 1 Day | 2 Days | 3 -4 Days | Over 4 Days | 1 Day | Grand Total | 2 Days | Total On Time | 3 - 4 Days | Over 4 Days | Total Late | ||
| 6 | ADAM M. BROUILLARD, ATTORNEY AT LAW (2867) | 2 | 1 | 3 | #DIV/0! | #DIV/0! | ##### | #DIV/0! | #DIV/0! | |||||
| 7 | ALLIED TITLE GROUP, LLC (2611) | 1 | 25 | 26 | 4% | 2604% | 0% | 0% | 0% | |||||
| 8 | ALOMA TITLE COMPANY (1107) | 1 | 6 | 7 | 17% | 717% | 0% | 0% | 0% | |||||
| 9 | ALOMA TITLE COMPANY (1113) | 14 | 3 | 40 | 57 | 35% | 5735% | 8% | 0% | 8% | ||||
| 10 | AMERICAN GUARDIAN TITLE USA, INC. (2795) | 2 | 41 | 7 | 2 | 36 | 88 | 114% | 8914% | 19% | 6% | 25% | ||
| 11 | AMERICAN TITLE TRUST LLC (2610) | 1 | 5 | 7 | 13 | 71% | 1371% | 0% | 0% | 0% | ||||
| 12 | ASSURE AMERICA TITLE COMPANY (364) | 12 | 1 | 2 | 20 | 35 | 60% | 3560% | 5% | 10% | 15% | |||
| 13 | AXIS TITLE, LLC (2501) | 3 | 16 | 7 | 5 | 36 | 67 | 44% | 6744% | 19% | 14% | 33% | ||
| 14 | A-Z TEAM TITLE, LLC (1072) | 3 | 64 | 19 | 7 | 96 | 189 | 67% | 18967% | 20% | 7% | 27% | ||
| 15 | BAILLIE & HERSHMAN, P.C. (795) | 2 | 11 | 13 | #DIV/0! | #DIV/0! | ##### | #DIV/0! | #DIV/0! | |||||
| 16 | BAND, GATES & DRAMIS, P.L. (2621) | 24 | 5 | 3 | 48 | 80 | 50% | 8050% | 10% | 6% | 17% | |||
| 17 | BERLING PATTEN EBLING, PLLC (2874) | 1 | 1 | 0% | 100% | 0% | 0% | 0% | ||||||
| 18 | BOGIN MUNNS & MUNNS (2789) | 1 | 1 | 5 | 7 | 20% | 720% | 20% | 0% | 20% | ||||
Summary-2022 YTD | ||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| H6:H18 | H6 | =C6/$F6 |
| I6:I18,L6:L18 | I6 | =G6+H6 |
| J6:K18 | J6 | =D6/$F6 |
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| I6:I34,I39:I86 | Cell Value | >0.7449 | text | NO |
