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

Answered

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

1 answer

WebDataRocks Team WebDataRocks August 10, 2020

Hello,
 
Thank you for reaching out to us.
 
Our team wants to explain that such empty columns appear due to the fact the subtotals are turned off. This behavior can not be changed in the current version of WebDataRocks.
 
Empty columns may be avoided by turning on the subtotals.
 
Also, we would like to kindly draw your attention to Flexmonster Pivot, which is the premium product developed by the same team. It has built-in functionality, allowing to hide corresponding columns in case subtotals do not need to be displayed.
 
We hope it helps.
Please contact us in case other questions arise.
 
Regards,
WebDataRocks Team

Please login or Register to Submit Answer