How to Hide Expression in Pivot Chart

[#1]

Hi Guys

       Is there any option to Enable and hide expression in Pivot chart

Regards,

Singam.

[santhoo_san]

use Conditional check box option under Expressions

[avinashelite]

go to expression  tab , check on conditional of the expression

here use: =false()

then go to presentation tab and un check the suppress zero option

[avinashelite]

[#5]

Hi Avinash

            Thanks for replying .But in conditional what type of expression we can wright

[avinashelite]

you can use any type of expression like based on certain calculated condition or based on selection anything you can use.

[#7]

We tried that option it is not working

[avinashelite]

can you please share the app

[Peter_Cammaert]

Hiding Expression columns in a Pivot isn't as straightforward as in a Straight table. There are multiple workarounds to get it to work, but they all depend on what you are trying to accomplish. The example below uses Avinash R's technique to show and hide an expression by selecting its name from a list.

Another solution would be to create an artificial dimension (using ValueList() function) to automatically hide an Expression column without values

To get it to work in your document, please provide more details or upload a sample app, as requested.

Best,

Peter