Deleting row subtotals in a Pivot Table

[tlrossi]

Want to hide or delete the row subtotals in a Pivot Table, but leave the group subtotal showing at the bottom of the subgroup. Just don't need every row subtotaled.

 

[GorD]

Double click the field button and then change the setting to none from auto.
You can also do this at the layout wizard stage

Hope that helps

 

[tlrossi]

ABR-109 ABR-109-801 Count of GRADE
Count of GRADE% 0.00%
ABR-109-802 Count of GRADE
Count of GRADE% 0.00%
ABR-109-803 Count of GRADE 4
Count of GRADE% 36.36%
ABR-109-804 Count of GRADE 3
Count of GRADE% 23.08%

ABR-109 Count of GRADE 7
ABR-109 Count of GRADE% 13.21%

Thanks for your response, but its not going to work. I have sent a small sample of the Pivot Table. I need to delete the % subtotals for the individual rows and only show the total % subtotal listed at the bottom.
Thanks for the help....