How to hide sub totals in pivot table?

[tkuia]

Hello!
Using pivot table with more the one field in the row area adds total lines.
How can I hide these lines?
Copy and paste to deferent area will not do good, since I need to change the table all the time.
The end result should look like:

Sum of count Month
model SN march april Grand Total
aa1 1 4 2 6
2 5 5 10
3 2 3 5
4 8 6 14
bb1 1 5 4 9
2 8 7 15
3 6 5 11
4 3 8 11
Grand Total 41 40 81

And NOT like:

Sum of count Month
model SN march april Grand Total
aa1 1 4 2 6
2 5 5 10
3 2 3 5
4 8 6 14
aa1 Total 19 16 35
bb1 1 5 4 9
2 8 7 15
3 6 5 11
4 3 8 11
bb1 Total 22 24 46
Grand Total 41 40 81



Thank you!
AlonS.

[paulmag]

Can you not right click on the line you want to hide and select hide or delete depending on your version of Excel? Right clicking in a pivot table opens a host of options

[tkuia]

Thank you, it works!