Rank list items based on multiple ranking levels
Hi Anaplan users,
I am trying to rank PO values by cost center & cost element & period & vendor & PO value.
See screenshot and blueprint view attached to follow my reasoning below:
I first want to show all POs from the vendor with the highest PO value at vendor & cost center & cost element & period level. That is what I calculated in the line item "Rank by vendor total". Lowest rank is the vendor with the highest PO value.
Then, within this vendor, I want to rank the POs descending according to PO value in rep currency. I calculated the line item "Rank within vendor" which I need to use in ascending order. (1 is the PO with highest value for that vendor).
Somehow I will need to come to a combination of the two line items to calculate one rank.
In order to do that, I would like to the rank by vendor total to go from 1, to 2 to 3,... instead of jumping from 1 to 10 to 24,... as you can see in the screenshot attached.
How can I change my rank by vendor total formula so that it jumps with steps of 1?
If I have accomplished that, I can multiply the two rankings and I can use that as the final ranking. That should work.
Thank you for hinting me towards the correct formula!