Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide total row in a pivot table

Hello,

In a pivot table, how to hide the Total Row if there is only one row appears above.

Look at this snapshot.

PivotTable.jpg

Thank you

1 Reply
swuehl
MVP
MVP

I think you can't hide / remove the partial sum total line in a pivot table based on a condition for single dimensional values.

There might be a work around if you create your total lines as dimensional values in your data model, but to answer this, you would need to post more details about your data model and data.