Dynamic Ranking with Native Timescale

Highlighted
Contributor

Dynamic Ranking with Native Timescale

Hi,

 

For a customer of ours I'm trying to build a dynamic ranking with the native timescale.

 

The 'regions' should be sorted from high to low based on a fixed line item but on the previous month.

 

Hope there is a workaround instead of manually sorting the values every month on the previous month in the dashboard.

 

Kind regards,
Hendrik

3 REPLIES 3
Highlighted
Community Boss

Re: Dynamic Ranking with Native Timescale

You can simply use the RANK formula in a line item and sort the display of the module by that line item.

 

Now how to exactly do it, it depends how your module is displayed and how you can tell which month is the previous month, but I can't help you on that without more details.

 

 


Nathan Rudman, Anaplan Model Builder
Highlighted
Master Anaplanner/Community Boss

Re: Dynamic Ranking with Native Timescale

Hi @HendrikDeCuyper 

 

Do see if the following works:

1. I've entered some random values for the different departments from Jan19 - Mar19.

Screen Shot 2020-02-24 at 21.44.13.png

 

2. Prev Value = Previous(Value)

Use the standard sort from Lowest to Highest for 'Prev Value'.

Screen Shot 2020-02-24 at 21.44.40.png

 

3. Pivot the module such that time is along the page selector. When you select any time in the page selector, the departments are sorted dynamically based on 'Prev Value'.

Screen Shot 2020-02-24 at 21.45.42.pngScreen Shot 2020-02-24 at 21.45.51.png

 

Thanks,

LipChean

Highlighted
Master Anaplanner/Community Boss

Re: Dynamic Ranking with Native Timescale

@HendrikDeCuyper 

Check out your earlier post about multiple lists with a RANK function. I think I may have captured what you need.

Only difference is that you need to change the RANK to use PREVIOUS(Sales) instead of Sales.

https://community.anaplan.com/t5/Anaplan-Platform/RANK-within-Multiple-Hierarchies/m-p/62144#M11333


Jared Dolich