I have a matrix with drill down option, for some categories there are 4 levels in the drill down where as for some others only 2 levels.
For the ones with only 2 levels , for eg in this case Write Off , i dont want blank to be displayed in 3rd and 4th level, how to do this?
Sample file attached:
https://drive.google.com/file/d/1GxPiajMP6seQSnRFa7eLVlJdm9Hvri8w/view?usp=sharing
Dont want these blank rows to appear
I tried using inscope function, hasonevalue functions , but not able to stop the drill down if there are blanks in the subsequent levels.
When filter is applied using these functions, it is affecting the entire visual.