hiding the column

[#1]

Hi,

Is it possible to hide the dimesnion in the Piviot or the straight table?

I have created a piviot/straight table with dimension A,B and expresssion is avg of c. So the expression is group by of B,A. Here i would like to hide the column b. But it should not have any impact on the result of expression it should work in a such a way that group by B,A

[nathanfurby]

I think you should post an example.

[wizardo]

hi xxx

in a straight table you can go to the presentation tab in the properties, there you can show/hide all columns(dimensions and expressions).

you can even use a condition.

in a pivot table the only way to hide is to collapse a dimension. and you cannot hide the expressions, just disable them.

Mansyno

[#4]

Hi,

I think that you use a two dimension for only group the values of your expression.

You can use the function "AGGR" to do this and you use only one dimension.