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!

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!