How to dynamically mask data?

Not directly but the second article (radacar...) has an idea that might be useful: splitting the original table into two.

I could split the "Secret" rows from the non secret ones... although I don't have any idea what to do next !!! 😂

My difficulty is that we need to hide column members dynamically depending on the presence or not of "non secret" data underneath and reporting everything hidden under an "Others" member that may or may not exist as well.

Finding out whether the numbers should be displayed normally is the easy bit I suspect...