How do i hide expression column in Pivot table

[#1]

Dear All,

               How do i hide Expression Column in Pivot table  ??

Can anyone help me !!

Regards,

Antony.

[Anonymous]

If you don't want it at all you can uncheck the Enable checkbox under the Chart Properties > Expressions tab

[#3]

Dear Johan,

            Thanks for your reply.

I want to hide the Expression not Disable. when i require that time i want to  Expand or visible the Hide Expression, is it possible in Pivot table.

The same thing i can do it in Straight table but i want it in Pivot table.

Regards,

Antony

[Anonymous]

Ok, are you hiding/showing the expression using a macro? In that case you can use a macro to enable/disable the expression instead.

In that case look up the Enable API in the API guide in the IExpressionData class.

[#5]

How do i use macro in Pivot ???

[Anonymous]

How do you hide the expression in the straight table?

[#7]

In Straight we have two options Hide column & Conditional Column. these options are not available in Pivot.

[deepakk]

hi,

PLease find a sample file for hiding and unhiding expression using macro.

Deepak

[#9]

Deepak,

               i checked its not hiding, its just showing some cross mars on above the object.

Antony.

[deepakk]

hi Antony,

Create a new one or change it to line chart and check.. Its working fine in my system.

Deepak