Sorting Pivot Table Depending on measure

[buster22]

Is there a way to sort the pivot table depending on the value measure which i called status. I have tried to sort using the dimension  'A' . Using : If([status]='Urgent', '1') to try and make sure urgent goes to the top. I would like urgent to be at the top for the latest dates. Thanks 

[raji6763]

hi Buster,

• under the sorting tab,you can sort by  expression
• you can customize your sorting order using  below expression
• match([status],'Urgent','2 weeks ago','X') based on your order
• then Urgent will be at the top.

regards,

raji

[buster22]

I tried to match using the dimension A using the match on the measure 'Status' but this doesn't seem to work.

 

[raji6763]

Did you uncheck the sort by numerically &alphabetically?

match function is a case sensitive .could you please check spelling ,space & upper lower cases in that field value.

[buster22]

Yes I have, I have used match before for a straight table but can't get it to work for this pivot table. thanks for the help.