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