Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm summing several columns of data in a pivot table with multiple rows. Is
it possible to set up the pivot table to also display the division of 2 cells of data in the same row. I want to view the summed values and also see the % value in a separate column. Is it possible to get the % Shipped calucalted as part of the pivot table set up in the example below? Sales Team Sales Ordered Sales Shipped % Shipped Salesperson 1 $30,000 $25,000 83.3% Salesperson 2 $15,000 $10,000 66.7% Salesperson 3 $50,000 $35,000 70.0% Thanks Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table - divide two results | Excel Worksheet Functions | |||
rounding off numbers gives an E in pivot table | Excel Discussion (Misc queries) | |||
Excel 2002 - Pivot Table : Can I divide instead of sum ? | Excel Discussion (Misc queries) | |||
How do you divide two cells in a pivot table to equal a %? | Excel Worksheet Functions | |||
Hide Pivot Table Divide by 0 error | Excel Worksheet Functions |