I need to write a “3D” expansion report (Expansion Across Sheet) based on Entity Dimension and the MemberSet selection is SELF, DEP. In all there are 20 sheets, but all of them do not have data. So my client want that only those Entity that has data should be shown in the report. Something similar to suppress function i.e. when we write ‘Y’ the rows with no data are not shown.
Similarly my client want that if any entity does not have any data then that sheet should be suppressed.
I am not sure how is this done in ‘3D’ report. Any guidance will be helpful.