Cyclic group in pivot chart as conditional dimension

[carolin01]

Hi

I´m trying to use a cyclic group in a pivot table that has lot´s of fields all enabled as conditional dimensions. But if I now to the same with my cyclic group its not possible to change between the fields of the cyclic group.

Does anybody have any suggestions why it´s not working or how I can make it working?

Best regards

Carolin

[maxgro]

see attachment

I suppose you have to use the group name (Time) in your expression Substring......, not the dimension (TransactionDate)

[Gysbert_Wassenaar]

I don't think I understand what you're trying to do. Are you trying to create a dynamic cyclic group? That can't be done using the conditional expression for the cyclic group column.

[carolin01]

Yes, that is what I wanted to do: A cyclic group combined with a conditional expression so that it will only appear if you mark "TransactionDate" in the Listbox. At the same time it´s a pivot table. And it can´t be done, right? Hm, that would have been a nice option to do.