If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Value filter missing in pivot table
I have a spreadsheet that totals sales and commisions based upon a date
range. Basically I've got two worksheets. One with the raw data, and another with the pivot table based upon the raw data. I've been unable to validate my totals as compared to other established reports. After digging into the report, I see that I'm missing 1 specific sales associate's data in my pivot table. I can clearly see a lot of data for this associate in the raw data sheet. While in the pivot table, I can go to the row label, and value filter, but this one sales associate is not listed for me to include in my manual filter. Can you help find my missing associate? BTW, I'm using Excel 2007 with SP2. |
#2
|
|||
|
|||
Value filter missing in pivot table
On May 12, 8:46*am, Ben B. wrote:
I have a spreadsheet that totals sales and commisions based upon a date range. Basically I've got two worksheets. One with the raw data, and another with the pivot table based upon the raw data. I've been unable to validate my totals as compared to other established reports. After digging into the report, I see that I'm missing 1 specific sales associate's data in my pivot table. I can clearly see a lot of data for this associate in the raw data sheet. While in the pivot table, I can go to the row label, and value filter, but this one sales associate is not listed for me to include in my manual filter. Can you help find my missing associate? BTW, I'm using Excel 2007 with SP2. Check the Range Selection for the Pivot Table, ie is that part of the source data for the pivot table. |
#3
|
|||
|
|||
Value filter missing in pivot table
Thanks Reeza. I checked and rebuilt the range selection but the issue persists.
"Reeza" wrote: On May 12, 8:46 am, Ben B. wrote: I have a spreadsheet that totals sales and commisions based upon a date range. Basically I've got two worksheets. One with the raw data, and another with the pivot table based upon the raw data. I've been unable to validate my totals as compared to other established reports. After digging into the report, I see that I'm missing 1 specific sales associate's data in my pivot table. I can clearly see a lot of data for this associate in the raw data sheet. While in the pivot table, I can go to the row label, and value filter, but this one sales associate is not listed for me to include in my manual filter. Can you help find my missing associate? BTW, I'm using Excel 2007 with SP2. Check the Range Selection for the Pivot Table, ie is that part of the source data for the pivot table. . |
#4
|
|||
|
|||
Value filter missing in pivot table
Hi Ben
if you want to mail me a copy, I will try and find what the problem is. to mail direct roger at technology4u dot co dot uk Change at and dots to make valid email address -- Regards Roger Govier Ben B. wrote: Thanks Reeza. I checked and rebuilt the range selection but the issue persists. "Reeza" wrote: On May 12, 8:46 am, Ben B. wrote: I have a spreadsheet that totals sales and commisions based upon a date range. Basically I've got two worksheets. One with the raw data, and another with the pivot table based upon the raw data. I've been unable to validate my totals as compared to other established reports. After digging into the report, I see that I'm missing 1 specific sales associate's data in my pivot table. I can clearly see a lot of data for this associate in the raw data sheet. While in the pivot table, I can go to the row label, and value filter, but this one sales associate is not listed for me to include in my manual filter. Can you help find my missing associate? BTW, I'm using Excel 2007 with SP2. Check the Range Selection for the Pivot Table, ie is that part of the source data for the pivot table. . |
Thread Tools | |
Display Modes | |
|
|