Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table % calculation
I need to calculate a % based on a grouped totalin a pivot table. I've tried
calculated field & items but can't get them to work. If I use a calculated item I get this: Reg1 Reg2 Item1 Sales 100 200 Item2 Sales 200 300 Total Sales 300 500 Item1 Margin 50 150 Item2 Margin 100 200 Total Margin 150 350 Item1 Margin% 50% 75% Item2 Margin% 50% 66% Total Margin% 100% 133% When the values S/B 50% and 70% I know this should be easy but I can't figure it out. Thank you all very much -- CSAHP |
#2
|
|||
|
|||
The subtotals in the pivot table will all use the same function -- in
this case they're all SUM functions. You could use conditional formatting to hide the Total Margin% row, and do your own calculation outside of the pivot table. CSAH wrote: I need to calculate a % based on a grouped totalin a pivot table. I've tried calculated field & items but can't get them to work. If I use a calculated item I get this: Reg1 Reg2 Item1 Sales 100 200 Item2 Sales 200 300 Total Sales 300 500 Item1 Margin 50 150 Item2 Margin 100 200 Total Margin 150 350 Item1 Margin% 50% 75% Item2 Margin% 50% 66% Total Margin% 100% 133% When the values S/B 50% and 70% I know this should be easy but I can't figure it out. Thank you all very much -- 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 | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot Table services | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |