pivot table and cycle group

[Anonymous]

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

[jonathandienst]

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