Cable Forum - View Single Post

liamboyle06 · 01-11-2006, 10:10

Can I hijack this thread for another Excel Question.

Using Excel 2003, I have a pivot table and am trying to work out percentages of a subtotal, but when I format the Pivot to show percentages, it shows percentages of the overall total, is there anyway I can change it to show percentages of the subtotals instead.
Attached is the info I am working on to have.

01-11-2006, 10:10	#9
liamboyle06 Inactive Join Date: Apr 2005 Location: St. Johnston, Co Donegal, Ireland Age: 46 Services: 3 Mobile Sky+ HD NWE 2MB Wireless Broadband XBOX 360 PS3 Wii Posts: 550	Re: Excel Question Can I hijack this thread for another Excel Question. Using Excel 2003, I have a pivot table and am trying to work out percentages of a subtotal, but when I format the Pivot to show percentages, it shows percentages of the overall total, is there anyway I can change it to show percentages of the subtotals instead. Attached is the info I am working on to have.