Negative + Positive ranking

[Anonymous]

Hi,

I want to rank items based on the lowest value so 

Fot worst sales i want it to say  worst 20 sales

Company name Rank Variance

Company name 1 -8000

Then for top 

Company name Rank Variance

Company name 1 9000

What would be the best way to go about this?

Thanks

C

[vanessafvg]

@Anonymous you can rank asc or desc  so either top or bottom.

[Anonymous · Accepted solution]

Yes - managed with 

Top Weekly Category = rankx(ALLSELECTED(menziesData[ANMW Category]),[Weekly variance],,DESC,Dense)