How show first ten items in a chart/table

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.

Accepted answers

All comments

JaredDolich

@Zoya

Rank is the way to go!

May I ask why your customer doesn't agree?

Show me the use case and I'll give you a step by step guide.

Basically looks like this:

convert users to a text value
Use rank
create boolean for top 10
filter on boolean

einas.ibrahim

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?

Zoya

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

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

Misbah

@Zoya

That's the limitation while using Native Users list. Here are all functions that do not accept the Users list as list argument.

CODE()

SUM()

LOOKUP()

RANK()

RANKCUMULATE()

CUMULATE()

TEXTLIST()

ISFIRSTOCCURRENCE()

IRR()

PROFILE()

NPV()

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…