Hide expression column

[fanninam]

I would like to hide the expression column.  Is this possible?

[krishnacbe]

Hi,

You are using Pivot table I hope. you cant Hide a expression in Pivot table.

You can convert the Pivot table to straight table and go to Presentation tab to Hide the expression.

[vishsaggi · Accepted solution]

How many expressions you have in this pivot.

Can you try checking Conditional option in Expression tab of your pivot properties and set the value to 0. like here:

[Anil_Babu_Samineni]

I doubt, How Conditional enable is helps you.

Here, What if second expression is depends on column(1). If you enable conditional as 0 for first one second expression should show null values only. I am not sure how you are handling and which bases you are modifying. Can you describe more your requirement to know the insight of User

[fanninam]

Anil,

There is only one expression.  When I set the one expression conditional as 0 it hid the column.

[Anil_Babu_Samineni]

Even if you have one expression, Then what is the use to create the Object here.

I know you got the answer, But some clarification to know your intend

[fanninam]

Hi Anil,

I want to show the employee names and their title but not show the headcount column.