Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Negative + Positive ranking

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

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Yes - managed with 

     

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

2 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Yes - managed with 

       

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