show only the subtotals and grand total in a pivot table

W

Wanna Learn

Morning! I have a pivot table and I need to create another report from this
pivot table that only shows the sub totals and totals . How do I do this?
thanks
 
D

Debra Dalgleish

You could create another pivot table, based on the first one, and show
only the fields that you want summarized.
 
W

Wanna Learn

Debra Excellent..... thanks

Debra Dalgleish said:
You could create another pivot table, based on the first one, and show
only the fields that you want summarized.
 
Top