How to hide summary field in Pivot table

  • Thread starter Thread starter Piotr
  • Start date Start date
P

Piotr

Hi I have Pivot table where I had grouped some fields, what I wish to
do is to make one group to summarise and other not to.
Becouse when I change properites I can only make changes to whole
group.
When I hide one others hide as well.
 
You could manually hide some of the rows, but you can't change the pivot
table to show only some of the subtotals for a field.

To hide a row, right-click on a row button, and choose Hide
 
Thank you I have done like that, sometimes the easy way is the solution ;-)

U¿ytkownik Debra Dalgleish napisa³:
 
You must log in or register to reply here.

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

Pivot table report invalid 0
Excel How to preserve column fields in a specific order in a pivot table? 2
"Pivot Table" option in Add / Remove buttons for Pivot Table Toolbar 1
Pivot Table Grouping Issue 2
pivot table calculated field 1
Pivot Table Help! 1
Pivot table calculated field Count(field) / sum(field) 0
Grouping In Pivot Tables 5

Back
Top