PDA

View Full Version : Solved: pivot table: sum column is incorrect



choubix
07-14-2008, 03:51 AM
hi again,
I created a field "total USD " using "pivot table -> Formulas" in excel.
the total USD is Quantity * USD Price

I show the price of the stocks (center of the pivot table), the name of stocks (left of the pivot table), per account and date (top of the pivot table)

the price is diplayed correctly BUT, when i hide the dates, the sum of the columns is incorrect.

any idea why is that please?

Bob Phillips
07-14-2008, 03:55 AM
Can you post an example?

choubix
07-14-2008, 03:57 AM
thought it could be linked to quantity being negative (because you can sell stocks...)

choubix
07-16-2008, 01:45 AM
found the buf was common with calculated fields (on support.microsoft.com)

managed to find a solution creating the calculated field in MS Query instead... now it works jsut fine :)

Bob Phillips
07-16-2008, 02:05 AM
Can you post the link FYI?