Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
4 years ago

Rank based on two columns

Hi experts! I know, there have been a lot of posts regarding this, but they have not been useful for me. The objective is to have a ranking based on two columns.   I have a dimension table (Table...
Need Help
smpa01's avatar
smpa01
Community Champion
4 years ago

joshua1990  the logic for RankTotal is not clear. Please bare more details as to how you arrived there?

joshua1990's avatar
joshua1990
Post Prodigy
4 years ago

smpa01: Thanks for your reply.

First, the Rank Total is based on the numerical value in Rank2. Then all remaining products are based on Rank1.

  • smpa01's avatar
    smpa01
    Community Champion
    4 years ago

    joshua1990  do I understand that if Rank2 =1 then that Product is Ranked 1 in Rank Total and rest of the products need to be Ranked again as per Rank1?