I've create a calculated field eg. price x quantity on a pivot table.
however, at the bottom where it sums up the column, it shows the sum of price
only. Is there something I need to do in order for it to sum the "calculated"
data? Thanks.
I've create a calculated field eg. price x quantity on a pivot table.
however, at the bottom where it sums up the column, it shows the sum of price
only. Is there something I need to do in order for it to sum the "calculated"
data? Thanks.
You should calculate the total price (price x quantity) for each row in
the source data table. Then, add that field to the pivot table's data
area, and you should get the correct grand total.
Natalie wrote:
> I've create a calculated field eg. price x quantity on a pivot table.
> however, at the bottom where it sums up the column, it shows the sum of price
> only. Is there something I need to do in order for it to sum the "calculated"
> data? Thanks.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks