Cycle button not visible in pivot table with two dimensions

[#1]

Hello

I have a pivot table with a row and column dimension. I have several expressions in the table that are in a cycle group. However the cycle group button does not appear on the pivot table, nor does the name of the current expression shown. If you do the same in a chart the cycle button appears bottom left and the current expression is shown in the title. Is there a way to make these visible in the pivot table?

Thanks.

[#2]

You can send an example?

[jonathandienst]

Hi

I think this is a known issue with pivot tables. To work around, you can create another object (eg a straight table) with the same cyclic group and no expressions. Reduce the size of this object until only the cyclic selector appears. Cyclic selections work across the model, so selections in this cyclic will update the cyclic in the pivot table.

On the layout tab, select a layer for this 'floating' cyclic button that is above the pivot table, and you can manually place it in the correct location over the table (or any where else you like!).

Hope that helps

Jonathan

[#4]

Thanks Jonathan. My cycle group is not defined in the document settings>group tab. It's definied in the expression tab for the table, so it doesn't have a name. I tried defining it the first way but couldn't get it to work. Can I still make this work-around work?

Many thanks.

[jonathandienst]

I have never tried that, but I have my doubts. The cyclic group trick works because cyclic groups are model level objects, but cyclic expressions are chart specific. So I suspect you are out of luck there.

There are several other options which should work for you:

• You might have to resort to conditionally displaying one pivot per expression using a state variable to control which one is displayed and one or more buttons to change the value of the state variable.
• Or use multiple pivots with auto minimize
• If you are using QV11, you can conditionally display expressions in pivot tables. Again you would use a state variable and one or more buttons

Regards

Jonathan

[jonathandienst]

BTW - if you grab the image for the cyclic and use that image for the state control button, you  would be faking the cyclic control so that most users would be unaware of the difference.

Jonathan

[#7 · Accepted solution]

Thanks

I decided in the end to avoid cycle groups completely and use an island inline file to create a listbox with the measures in. Then set a variable to hold the expression depending on which one was selected in the list box.

Phew!