Hide expressions in Pivot table

[#1]

Hi All

I want to create a pivot table and show certain expressions only under certain group.

For eg : In the attached file, I want to show Enterprise Infra Support, Personal Support etc under Fixed and Avamr, Projects under variable. I have used IF condition, still it is showing up under both.

Please advise.

[sujeetsingh]

Try Expression Grouping if possible

[#3]

Can u pls elaborate

[#4]

Hi Paramita Sahu,

Did you get a work-around to this question? I am having exactly the same requirement!

Thank you in advance,

/Yolanda

[ashfaq_haseeb]

Hi,

To hide expression just give wrong calculated condition in Conditional value.

Have a look at attached image.

Regards

ASHFAQ

[#6]

Thank you Mohammed,

But this will hide the expression for all the dimensions. What I need is to hide the expresion for certain dimensions (I want some columns to appear only for a specific value of one of the dimesions).

BR,

/Yolanda

[ashfaq_haseeb]

Can you share sample application with Expected output

Regards

ASHFAQ

[#8]

Something like:

[deepakqlikview_123]

why u are not uncheck expression in expression tab.

[#10]

Hi Yolanda,

Have you solved the problem yet?

As I'm facing the same problem of hiding columns in pivot table, Thanks!

Best Regards,

Crystal