Show/Hide Columns of Graph Based of a List

[cristian_av]

Hi

I have a pivot table and I want to hide/show some columns based on a selection of a field.

I'm using this expression to hide/show them:

=Substringcount(','&concat(distinct Dimensiones, ',')&',', ',Especie,')=1

The trouble is that when I UnSelect All, all the columns appears, and I need that they appear only if selected.

In other words, as default, columns should be hide.

Any idea? Thanks!!

[cristian_av · Accepted solution]

Solved!

=if(GetSelectedCount(Columnas)=0,0,Substringcount(','&concat(distinct Columnas, ',')&',', ',Especie,')=1)

[ramasaisaksoft]

Hi KJH,

I hope you are asking in Ad-hoc Reporting concept?

any way you got the solution as per your expectations so please close the thread.