Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think you should post an example.
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
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.