Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have searched through all the posts and can't find the answer I am looking
for. I have a pivot table where I am trying to get the percentage of the subtotal for each item, but it only lets me get the percentage of the grand total. I saw a previous example which basically summed up the percentages which not work in my case. The following is what I would like to see...but I keep getting either #n/a or percentages of the grandtotal which are not going to work. Vehicle Dept Miles Percentage Car 1 A 10 10% B 10 10% C 80 80% Car 1 Subtotal 100 100% Car 2 A 20 20% B 80 80% Car 2 Subtotal 100 100% Grandtotal 200 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need running percentage in pivot table | Excel Discussion (Misc queries) | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
How to add a percentage column in a Pivot Table | Excel Discussion (Misc queries) | |||
Percentage calculation in pivot table | Excel Worksheet Functions | |||
Pivot table from CSV data, problem with percentage of total. | Excel Worksheet Functions |