Hey!
We truly hope that our free tool comes in handy for your business, especially these days. Follow our news, stay safe & pivot on!

how to hide the empty cells/columns for multi level columns

Open

Hi, 
I have  4 levels columns as, Year of Date, Month from the Year, Quarters of year, and then Week. 
and having 3 field values as the sum of Quantity, Sum of the Purchase price, and Sum of the Sales price.
when expands the year, I can see the empty columns under that year. Same for the next levels…Please check the attached image for reference.  
So how to remove those empty columns …

Attachments:
pivot.png

Please login or Register to Submit Answer