Hi - I would like to sort on more than one dimensions using expression sort in a pivot table. For ex let's say
I have Family GCI, Family Name, NAICS and my expression has set analysis which ignores any selections, therefore the no of records in this pivot table will always be same. Now If user selects one Family GCI, then I would want that Family GCI to be at the top and then all Family GCIs associated with that selected Family GCI's NAICS should be listed below (this is my second sort). So how do I achieve this by using the expression.
In my expression I have
=if(len(FamilyGCI),1,2)
so it does the first sort correctly, meaning my selected GCI comes first but how to get all GCIs linked with same NAICS to sort after this.
