Getting % of subcategories in pivot table

[stephme55]

Hello. I have a column in a pivot table that I want to calculate each row as a % of a subcategory (there are states and then there is a column total). I can't find this option. I want the rows to show up as a % of EACH state. Not as a % of column total or grand total. Thanks.

[NeedForExcel]

Try out the option that says % of Parent Column Total..

[stephme55]

It was actually % of parent row total. Thank ye!!

[NeedForExcel]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.