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.

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.

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.
.

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.
.

Try putting a title at the top of each column!

Without the column it will not count the top value.