Hello. I have one problem with asceding sorting in anaplan So, for example: I have module with dimensions: Users, Time, Line Items (value). I need to filter my values in the way to show only top10 values on the chart. Are there any ideas or tricks how to do it? I faced a problem that fuction 'RANK' doesnt work with users.
I had this idea. But the problem is that you can only collect data using formulas from fake users to anaplan ones. In fact, I couldn't think of anything better than: 1. Create a module similar to this one, but on fake users 2. To make the imports in this module 3. use rank 4. Add the result to the source module using formulas I do not really like the heaviness of this decision. Because I have to use import under the "show only top10" button
I did not know that Rank() doesn't work with user lists, it's not in the Anapedia page of the function. But I see the error when I try to use Rank with a module dimensioned by users. I am very curious to know why is that restriction in place? If anyone knows the reason please share.
@Zoya What is the main purpose of including the Users list in the module?