Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

rankx by group

I am using the below formula to rank sales results.  I would like to group the ranking by a column of Profit Center's.  What can I add to the below formula so that the ranking column adds a ranking b...
  • Anonymous's avatar
    Anonymous
    10 years ago

    Total Sales is a calculated field. 

  • Anonymous's avatar
    Anonymous
    10 years ago

    Good news...your feedback works!  I had to make a small adjustment in my formula and it worked perfect.  Thanks for all your help!

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
10 years ago

hi Anonymous

 

Ranking = RANKX(FILTER('Sold-To-Database';'Sold-To-Database'[Profit Center]=EARLIER('Sold-To-Database'[Profit Center]));'Sold-To-Database'[Total Sales];;DESC;Dense)

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi Victor,

     

    Thanks for your feedback.  Based on your suggestion I entered the following formula and received the below error.

     

    Thoughts?

     

    Tim

     

    Ranking = RANKX(FILTER('Sold-To Database','Sold-To Database'[Profit Center]=EARLIER('Sold-To Database'[Profit Center])),'Sold-To Database'Sold-To Database'[Total Sales],DESC,Dense)

     

    • Vvelarde's avatar
      Vvelarde
      Icon for Community Champion rankCommunity Champion
      10 years ago

      Anonymous

       

      Work with a Calculated Column.

       

      Regards

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Total Sales is a calculated field.