Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have attache a sample application. Here my requirement goes like below.
1.When there is no selection (Clear All) my dimension needs to be sorted as a "A-Z"
2.When I am click "List" the pivot table needs to be sorted as per Id column which I implemented.
All I need is with out any selection I need to sort the columns in "A-Z" manner
-Jay
Maybe like attached, using a sort expression like
=If(GetSelectedCount(Id), Ord(Rules),min(Sort))
Hi swuehl,
Thank you for your quick response.Your solution worked (almost ) when my Rules defined in Upper case(N). But when my Rules defined with Small case(n) it is not working.
Sorry for the inconvenience. I found this when I am testing with real data. Is there is any solution.
FYI,
Attached lower case scenario
-Jay
Maybe like
=If(GetSelectedCount(Id), min(Sort),Ord(lower(Rules)))