Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
I do have a pivot table with two dimensions and two expressions. The expressions are grouped by a cyclic group.
One dimension is shown in rows, while the other dimension is shown in column and the value of the expression in
correspondending cells.
BUT: in this scenario the "Cyclic Group" is not on display. I cannot switch between my expressions (as required).
Furthermore I donot see which expression is on display.
Dim 2
Dim 1 ValExpr1
-> If both dimensions are shown in rows, the cyclic display is on display. But I need it the first way!
Cycle Group
Dim 1 Dim2 ValExpr1
Workaround with my table without cycle group: switch to barchart, switch to desired expression and goback to
pivot table.
Any ideas how the cycle group can be shown in my scenario?
Regards
Hi
You might need to make two tables (one for each expression). You could then use autominimise, a container or conditional display to swicth between the two.
Not quite the same, just some workarounds.
Regards
Jonathan