Hide or show values in Dimension

[Ronald]

Hi,

In my pivot I want to show or hide values if have a condition:

Hide BALLESTEROS because in Producto have a condition APRO

[Or · Accepted solution]

No promises this will work for every scenario, but at least in a basic one, it should work correctly:

=if(Wildmatch(Aggr(Concat(Producto),Medicos),'*APRO*'),Null(),Medicos)

And make sure this dimension has Suppress Null Values enabled.

Replace the '*APRO*' with whatever condition it is you are checking against, assuming that condition is a specific Producto. If it's something else, you may have to get creative with adapting this approach.