To Hide Blanks Cells with multiple dimensions in a Module

Question

Hi All,

I have a scenario where i wanted to hide the blank cells. (Blank cells - switchover versions using DCA). As Per my below screenshot,i want to hide JAN 22, FEB 22 , OCT 22, NOV 22 AND DEC 22.

Thanks,

Aish

M.Kierepka · Answer

Hi,
You need to create Boolean filter that has all the dimensions that you have in columns and pages (so without rows dimension), and then it should be true only if all cells in some columns are false (something like "NOT X[ANY:Y]". The problem can be with native Versions that I think you use - then you need to write a formula separately for each version with [SELECT:] clause.