How show first ten items in a chart/table

Options
Zoya
Zoya Member, ALL USERS, Partner, Certified Model Builder Posts: 3 Occasional Contributor
in Planning & Modeling

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. 

Tagged:

Comments

  • Zoya
    Zoya Member, ALL USERS, Partner, Certified Model Builder Posts: 3 Occasional Contributor

    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

  • Zoya
    Zoya Member, ALL USERS, Partner, Certified Model Builder Posts: 3 Occasional Contributor

    Long story. This is due to filters. Each user has own set of filters that cannot be used just like filter to dimension

Categories