Dynamic Ranking with Native Timescale

HendrikDeCuyper

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

Accepted answers

JaredDolich

@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

All comments

nathan_rudman

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.

LipChean_Soh

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.png

Thanks,

LipChean

JaredDolich

@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

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…