How to filter level values if now data exists in Demantra worksheets?
I Have a filter also on this worksheet to filter only one ITEM # 4800000464.
This item is exclusively sold to only one Key Customer Wal Mart.
But my worksheet is showing all the other key customers also in Page layout section.
Hide Empty Rows / Hide Empty Columns is only controlling the result data, but not on the aggregation levels.
Is there any solution for this.
Sample data Screen shot is enclosed to this Post.
Regards,
Kumar.