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

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…