Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator II
Creator II

sorting is lost

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 !!

1 Reply
vikasmahajan

If your Cyclic Group names are standard then Base on Cyclic group you can sort

using  expression.

Hope this helps.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.