Hi all,

I am trying to work out the % of cost to sales.I have using a pivot
table to get the sales & cost dat and manually calculated the %
I know that Excel has pivot table % in the field settings- options but
they do not give me what I am after.

Is there a solution using pivot tables?



Genre Fiscal year Sum of Sales £ Sum of Cost £ %
CH V4/2003 48,607 (422) 0.87%
V4/2004 49,284 (785) 1.59%
V4/2005 52,816 (2,052) 3.89%
V4/2006 35,165 (722) 2.05%
V4/2007 47,812 (956) 2.00%
V4/2008 59,255 (934) 1.58%
CH Total 292,938 (5,871)
2.00%


Thanks
TW