Make subtotals 100%

[Guest]

My column fields are 'Years'I want in the first column of 2002 every subtotal
number to represent 100%. I then want year 2003 subtotal numbers
increase/decrease to show the new percentage e.g.
2002 subtotal 1 [43] [[100%]] subtotal 2 [165] [[100%]]
2003 subtotal 1 [45] [[104.65%]]subtotal 2 [171] [[103.64%]]

 

[Dave Peterson]

Try this against a copy of your worksheet.

Do your data|subtotals.

But then convert the =subtotal() formulas to values (maybe do the whole
worksheet and get rid of the formulas???)

Then use the outlining symbols on the left to show only the subtotal lines you
want.

Then select the "basis" row (2002?).
copy it.

Then select the remaining data
edit|goto|special|visible cells only
edit|paste special|check divide.

Then do it again for the "basis" row (2002) or just change those all to 1's.

Select those cells again (and use edit|goto|special|visible cells only)
and format them as percentages.

But you have lost the formulas when you do this.

My column fields are 'Years'I want in the first column of 2002 every subtotal
number to represent 100%. I then want year 2003 subtotal numbers
increase/decrease to show the new percentage e.g.
2002 subtotal 1 [43] [[100%]] subtotal 2 [165] [[100%]]
2003 subtotal 1 [45] [[104.65%]]subtotal 2 [171] [[103.64%]]