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.
Go to Solution.
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.
View solution in original post
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.
Do see if the following works:
1. I've entered some random values for the different departments from Jan19 - Mar19.
2. Prev Value = Previous(Value)
Use the standard sort from Lowest to Highest for 'Prev Value'.
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'.