How to hide an expression in pivot table?

[#1]

I have few expressions in the pivot table but i don't want to show the values of all. I just need a way to hide the expression and  i can use that hidden expression column in calculating another expression. Find the attachment for the example. How can i hide an expression in pivot table but still use in calculating another expression?

Exp1 (hidden)	Exp2 (hidden)	Exp3=Column(2)-Column(1)

The way i am trying to do this is for the expression(Exp3) using the columns from previous expressions which should be hidden.

[alexandros17]

here it is

[PrashantSangle]

Hi,

Goto Chart properties-> Expression->Enable(uncheck)

It will solve your problem..

[#4]

Thanks for the input.

But,this one does serve the purpose to hide the expression, but in this case i need to hide the expression but still need to use that column to calculate another expression?

[#5]

If we uncheck, which means it does disable the expression and that is not going to work in this situation.

[sudeepkm]

I think you can achieve that in a straight table using hide column.

[PrashantSangle]

Hi,

Go to Presentation tab

Select Your Expression->check(Hide Column)

[alexandros17]

In pivot that is the only way, otherways select straight table

[#9]

Yes, but i would need to use the pivot table rather than straight table to show the grouping view.

[sudeepkm]

Workaround in Pivot table.