How to sort a bar chart’s dimension by a measure not included in the chart

[DerickMulder]

Hi Guys

I want to know is there a way to sort my bar chart’s dimension ( account name ) by a measure that is not with my bar chart

data table looks lik

BRANCH |Rep | Rep name | Acc name | ytd sales |mtd sales

in my chart acc name is the  dimension and mtd sales is the measure but i want to sort my dimension by ytd sales but i do not want to show ytd sales in my chart

any help would be awsome

thanks guys

[trdandamudi · Accepted solution]

Yes, you can sort by ytd sales. Take a look at the attachment:

[DerickMulder]

Hi Man

Awesome it works perfectly thank you!

[trdandamudi]

You are welcome... Glad able to help .