Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
you could try this sorting expression:
If(
Match([CAT],'Cameras','Computers & Laptops','Consumer Electronics','Health & Beauty','Mobiles & Tablets'),
Match([CAT],'Cameras','Computers & Laptops','Consumer Electronics','Health & Beauty','Mobiles & Tablets'),
100)
hope this helps
regards
Marco
Hi,
you could try this sorting expression:
If(
Match([CAT],'Cameras','Computers & Laptops','Consumer Electronics','Health & Beauty','Mobiles & Tablets'),
Match([CAT],'Cameras','Computers & Laptops','Consumer Electronics','Health & Beauty','Mobiles & Tablets'),
100)
hope this helps
regards
Marco
or
Match([CAT],'Mobiles & Tablets','Health & Beauty','Consumer Electronics','Computers & Laptops','Cameras')
in descending order
hope this helps
regards
Marco
Many Thanks Mr. Marco wedel.
Have a nice day!