How to hide expression in pivot table

[yoganantha321]

Hi,

I am having a pivot table as below:

I want to hide the expression used in the the table.

I have tried with the straight table but it is showing the duplicating the name for 'N' number times.

Can anyone help in this!?

Regards,

Yoganantha Prakash G P

[vinieme12 · Accepted solution]

if you want to use a pivot table only to show the data then no need to an expression, just uncheck suppress zero values in presentation tab

[Sergey_Shuklin]

Hello!

If you want to disable expression - just uncheck the Enabled option in Expression tab.

If you want to hide it - go to the background color of it expression and set ARGB(0,0,0,0) - it will make all values invisible.

[sudeepkm]

another way of hiding the expression in Pivot table would be to put a condition like 1=2.

[vinieme12]

why not simply disable or delete the expression instead of spending system resources on calculating another condition!

[Peter_Cammaert]

As an alternative, why not concatenate all values and show them in a listbox, then switch the listbox to Tree View?