Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.
another way of hiding the expression in Pivot table would be to put a condition like 1=2.
why not simply disable or delete the expression instead of spending system resources on calculating another condition!
As an alternative, why not concatenate all values and show them in a listbox, then switch the listbox to Tree View?