Hiding a dimension in Pivot Table

[#1]

Is it possible to hide a dimension in Pivot Table?

Thanks in advante,

Lucas

[SunilChauhan]

in pivot its not possible. but u can hide in straight table.

properties-->Presentation->select dimension---> check radio button

and see ur result..

[#3]

hi Lucas

we can also hide the column in straight table based on condition.

[#4]

Thanks, but i really need this in pivot table.

[#5]

Hi,

Do you need the dimension just for to calculate your expression?

Maybe you can use the function AGGR() in your expression and don't need more the dimension that you want to hide.

[#6]

hi,

one more thing you can do with pivot table. just show your calculation in expression and drag the expression column to dimession level.

sumit