Hide Expand All

[#1]

Hello,

I have a pivot table that looks like:

and I want to make it look better.

First of all, I need to hide those lines with LineDescription2, LineDescription3 or LineDescription4 null (I want to make the lines with no children not expandable, i.e. hide the + sign for Line8, and Line7, -).

The second question is how can I set the width for the Period column to 0?

Do you have any suggestions?

Thank you!