Percentage of Subtotal in Pivot Tables

[incognitos]

Hey,

I've been looking through some of the forums, but i just can't figure out how to do this.

I'm trying to find percentages of subtotals in pivot tables (preferrably in a new field (within the pivot table itself), so it can auto-update itself).

Right now, my pivot table's top most row field is "Accounts", which then breaks down by "Product Type","Category", "Sub Product Type", and "Name".

So what I"m trying to do is break down the "Category" in each "Product type"
and then further break down each "Sub Product type" in each "Category".

Is this possible? Thanks for all the help.

[steven1001]

http://www.excelforum.com/excel-gene...ot-tables.html
may cover same question in last post