Hi,

Please show us the source data.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Michelle" wrote in message
...
I have searched through all the posts and can't find the answer I am
looking
for. I have a pivot table where I am trying to get the percentage of the
subtotal for each item, but it only lets me get the percentage of the
grand
total. I saw a previous example which basically summed up the percentages
which not work in my case.

The following is what I would like to see...but I keep getting either #n/a
or percentages of the grandtotal which are not going to work.

Vehicle Dept Miles Percentage
Car 1 A 10 10%
B 10 10%
C 80 80%
Car 1 Subtotal 100 100%
Car 2 A 20 20%
B 80 80%
Car 2 Subtotal 100 100%
Grandtotal 200