Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple Pivot Table question - I'm stumped
I have a huge pivot table with data like
StoreA WidgetSales TotalSales StoreB WidgetSales TotalSales StoreC WidgetSales TotalSales (Stores are in column field, both WidgetSales and TotalSales are in data field) I need to calculate WidgetSales as % of Total Sales, so I was thinking about copying and pasting the above data in order to do this StoreA WidgetSales =WidgetSales/TotalSales TotalSales StoreB WidgetSales TotalSales StoreC WidgetSales TotalSales But, how would I copy that formula all the way down to get a % for all the stores? (there is a gap between the cells going down so the cells are not contiguous) Is there a way to calculate that % somehow in the pivot table itself, without going through this rigmarole? Thanks in advance for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple Pivot Table question - I'm stumped
Jay
I hope I'm understanding, if so then right click the widgets data and select 'Field Settings', Click the Options button and select from the dropdown, % of column (I think that's the orientation of your data, if not then % of row). If you need it showing as both values and a % of then add the field twice -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "jay g" wrote in message ... I have a huge pivot table with data like StoreA WidgetSales TotalSales StoreB WidgetSales TotalSales StoreC WidgetSales TotalSales (Stores are in column field, both WidgetSales and TotalSales are in data field) I need to calculate WidgetSales as % of Total Sales, so I was thinking about copying and pasting the above data in order to do this StoreA WidgetSales =WidgetSales/TotalSales TotalSales StoreB WidgetSales TotalSales StoreC WidgetSales TotalSales But, how would I copy that formula all the way down to get a % for all the stores? (there is a gap between the cells going down so the cells are not contiguous) Is there a way to calculate that % somehow in the pivot table itself, without going through this rigmarole? Thanks in advance for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Question | New Users to Excel | |||
Pivot table - Custom calculation question | Excel Worksheet Functions | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel |