Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
The cyclic group in my document is created by macro(as we want a different field name for different user).
These cyclic groups are used in straight or pivot tables.
The issue is, I do the sorting by a particular expression column, but this sorting is lost and sorting by first dimension is automatically created(dim1 comes on top in sort tab), once i close and open the document.
I assume the issue is with the macro that creates the cyclic group, but not sure.
Please suggest !!
If your Cyclic Group names are standard then Base on Cyclic group you can sort
using expression.
Hope this helps.
Vikas