3 Replies Latest reply: Oct 19, 2014 10:32 PM by Robert Bosco JOHN PETER RSS

    Customized sorting by Calculated Dimension

      Hello everyone,

       

      I have created the calculated dimension attribute(like below script) in my pivot table and i want sort the column by ascending exclude 'others ' as i want show the 'others' in the last row.

       

      =if([CAT]='Mobiles & Tablets', 'Mobiles & Tablets',

      if([CAT]='Computers & Laptops', 'Computers & Laptops',

      if([CAT]='Consumer Electronics', 'Consumer Electronics',

      if([CAT]= 'Cameras', 'Cameras',

      if([CAT]='Watches', 'Watches',

      if([CAT]='Health & Beauty', 'Health & Beauty',

      'Others'))))))

       

      Label name is : Category

       

      I tired below script in the sort tab expression but it doesn't work :

       

      WildMatch(Category,'Cameras',Computers & Laptops','Consumer Electronics','Health & Beauty','Mobiles & Tablets','Others')

      or

      Match(Category,'Cameras',Computers & Laptops','Consumer Electronics','Health & Beauty','Mobiles & Tablets','Others')

       

      could you please advise me ?

       

      Best,

      Robert