Sorting Help

[Anonymous]

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

[swuehl]

Maybe like attached, using a sort expression like

=If(GetSelectedCount(Id), Ord(Rules),min(Sort))

[Anonymous]

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

[swuehl]

Maybe like

=If(GetSelectedCount(Id), min(Sort),Ord(lower(Rules)))