Pivot table only picking up random parts of source data

pikinini_org

New Member
Joined
Feb 26, 2020
Messages
2
Office Version
  1. 2010
Platform
  1. Windows
Hi I've created a worksheet which has two pivot tables drawing from the same source-data. So the pivot tables - both - are not reflecting the correct data. So I clicked on 'show details' - which of course - brings up another sheet showing the specific filtered data being used. The filtered data is only a fraction of the whole data-set. I do not know why the tables are not picking up the full data-set! Further, they're both picking up mostly different entries. The source has 134 rows, 43 of which I've filtered out with the Report filter - leaving 91 relevant row entries. According to the 'show details' sheets, PT1 is showing results for only 6 rows; PT2 is showing for only 9. Of the 6 and the 9, only 5 are the same being picked up.*

Here's what I've tried:

-Refreshing
-Double-checking the source data (the PTs draw from a table so it should factor in new entries and this seems to be working when viewing the source data field).
-Making sure all the correct filters are turned on or off for what I want shown in the PTs (I have manually calculated the correct values to compare to see if the PT is working or not).
-Making sure all the value field setting are correct (they're all averages, like I want them).
-Checking the source data for entry mistakes such as blanks and/or spaces. Everything seems to be in order. In any case, the two PTs - respectively - are picking up different random entries to each other. Neither the correct filtered data. Both, only a few entries. But this would suggest to me that the problem is with the tables, not with the source? Cause they're both picking up random bits?
-I've tried looking at the entries which are being used to see if there's any similarities or things they have that other data doesn't. I can't see any.

I'm pulling my hair out! Please help! Also big thanks to these forums for solving all of my excel problems up until now! Why are my pivot tables not recognizing the full data-source-set?!

*Picked up: Idk the correct terminology. I'm talking about the specific rows from the data source which the details worksheet show are in use in the pivot table..
ps. I'm using Excel 2010 on my old work laptop.
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

pikinini_org

New Member
Joined
Feb 26, 2020
Messages
2
Office Version
  1. 2010
Platform
  1. Windows
Just in case anyone's checking this - I figured it out. Moderators please delete :)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,098
Messages
5,545,951
Members
410,713
Latest member
TaremyLunsil
Top