Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Would appreciate assistance with Calculated Fields in a Pivot table.
I would like to perform a calculation which invovles a reference to the total of a field generated in a pivot table. I would like to calculate the average total sales for a sales team, by dividing each sales persons total sales, by the teams total sales. I have tried using the average function, but this only calculates each individuals average for each sales item. I cannot work out how to refer to totals generated by pivot tables in a formula. Can anyone assist? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
Calculated Field in Pivot Table | Excel Worksheet Functions | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) |