Percentage of parent row in Pivot Table

A

alevo

Hello,

I am trying to see my data as "% of parent row" in excel pivot tabl
but this is not possible. I can select show data as "% of column" bu
this percentage is calculated based on the total of all data in column
I just want to see the percentage for that parent row. In Access thi
is possible. I just need to choose show data as "Percent of Parent Ro
item" when I am creating an auto form: Pivot table.

I don't know is this feature exists in excel, may be it exists in othe
version of excel (I am using excel 2002, now). How can I know tha
specification is already exists or not? If yes how can I use it?

Thanks a lot for your help

Best Regards,

PS: I attach a sample file to explain my problem clearly.

Levent Topkar
 
D

Debra Dalgleish

If you're trying to calculate the percent of a subtotal, you can't do
that in a pivot table. You could do the calculation with formulas
outside of the PivotTable.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help on pivot table 1
Access #Error & Excel Pivot 0
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Excel Pivot Table How to Sort data as Percent of Row 12
Pivot using 250,000 rows of data in Excel? 1
Pivot Table 2
Unable to Group in Pivot Table 1
subtracting two pivot table data fields 1

Top