% of Subtotal in Pivot Table

[Andreea`]

Hello. I have a pivot table report with two row labels. I have to calculate the percentage for the subtotals of one row label, not from the Gran Total. How can I do this?

 

[RoryA]

Which version of Excel? In 2010 you can do that in the pivot table, but not in earlier versions.

 

[Andreea`]

In 2007

 

[Andreea`]

But isn't there any other way to do this?
Can I insert a formula that automatically calculates the percentage per subtotal ( is a very large tablel and I don't do this manually)? If yes, how?

 

[RoryA]

Could you give more details? You can display values as a percentage of a whole row or column, or of the grand total, or of a specific item in one of the fields, but you cannot display items as a percentage of a particular subtotal, if that's what you mean?