sorting in dimension

[#1]

Hi,

I have a field called 'Main Segment' and i want to use it as a dimension.

like this(=if(Product='bikes', mainsegment)) and the order in mainsegment is:

City

E-Bike

Trekking

and i want them to be like :

E-Bike

City

Trekking any help will be appreciated

Best,

Ab

[PrashantSangle]

Hi,

In Sort tab-> you can write expression-> in that write

Match(Product,'Your Sort order Product')

Regards

[#3]

thanks Max for your reply.

but  this is the dimension I have right now: =if(Product='bikes', main segment) where does the  'Your Sort order Product' go?

[PrashantSangle]

In Sort tab write below expression

wildmatch(mainSegment,'E-Bike','City','Trekking')

Regards