Hello everyone,
I have a file with a large set of data (directly retrieved from an ERP) which has hundreds of lines and columns.
My goal is to make this schedule presentable by removing all rows or columns that sums up to 0.
My first idea was to make a pivot table.
In order to hide the rows equal to zero I added a column which checks if the total row is equal to 0, then I can filter those empty rows thanks to this field in the PT.
However, I cannot find a way to hide the columns which sum up to 0...
Did anyone already have the same issue?
Thanks a lot for your ideas!
Bookmarks