Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculated field based on data field
How do I create a calculated field that is the division of two sum data
fields? (i.e., two cells in my pivot table) The field list when going to calculated fields does not show my data fields... For example for the below I would want to calculate (sum of price)/(sum of Balance) for each CategoryXFuture Category cell. How do I do that? Future Category Category Data A B C A Sum of Balance 23.4 25.7 49.0 Sum of Price 10.3 21.9 10 SumofPrice/Sumof Bal. ? ? ? B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a field name in an IF function for a calculated field in a PivotTable | Excel Worksheet Functions | |||
Unable to change field settings in calculated field in a pivot tab | Excel Discussion (Misc queries) | |||
Calculated Field in Pivot Table Based on Two Counted Fields | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Pivot table help:calculated field based on previous consecutive va | Excel Discussion (Misc queries) |