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!