Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot table where I added a cyclic group as the dimension. Everything works fine in the client, but when I move it to the server (ajax) the cyclic group dimension dissapears from the pivot table. Anyone experienced this before and know how to resolve it?
Is there any good alternatives to cyclic groups? Calculated dimension with variable input from a button maybe?
The ajax client is missing the dropdown box for cyclic groups, but you can right click the cyclic group button.
Alternatively you could create a small inline table in the script with the field names you want in the cyclic group. Add a listbox for the new field, select one value and enable the option Always One Selected Value on the properties window of the listbox. In place of the cyclic group you can use a calculated dimension =$(=MyField). See attached example.
Thanks for your reply, but the dimension is missing entirely from the pivot table when on the server. So no cyclic group button to press unfortunately