Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table: Calculated Fields
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table: Calculated Fields
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Calculated Fields | Charts and Charting in Excel | |||
Pivot Table Calculated Fields | Excel Discussion (Misc queries) | |||
Pivot table and calculated fields | Excel Discussion (Misc queries) | |||
Pivot Table with Calculated Fields | Excel Discussion (Misc queries) | |||
Sum of Calculated fields in Pivot Table | Excel Discussion (Misc queries) |