Hi, a common problem I hope:
I have a list of accounts, your general run of the mill list. For example lets say I have 40 entries for pens, 800 entries for paper, 400 entries for stress balls.
I can put a subtotal function at the foot of the page and get the total amount. If I create a pivot table from the same data I always get a lower number?
Some amounts are negative and represent refunds or cancellations, things like:
Pens £148.00
Pens -£148.00
The subtotal is correct at the foot of the worksheet.
Why can't I get the pivot to add up properly?
Could you post an example file? Click Go Advanced and Manage Attachments. I've never come across that problem in many years of using pivot tables.
Isn't that typical, when I need it to it won't!
Had the problem working with multiple filtered data. That poses the more interesting question, can I filter data then run a pivot on only the exposed, or rather have the pivot update as the filtering changes?
This would mean I can sort and arrange data on the fly and all my charts would be updated. Currently I'm copying data to a static sheet and creating a chart based on that.
If you find this works for you, my issue mus sit with multiple filters.
Last edited by datacruncher; 12-08-2009 at 01:15 PM.
Could you apply the filters to the pivot table instead of the data sheet?
I'll try it and see how I get on. Sounds good in principle!
I might guess your pivot source is not covering all your data, uploading an example would really help.
CC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks