Boolean Filter for Salary Rank function

Hi,

I want to only show the top 10 earners in each department (List hierachy E1 Department is top and E2 Employee below).

I have created a RANK that will give organize numbers lowest to highest based on each department, But the numbers do not "start over" for each department. So there is only one department, that has RANK 1, 2, 3 values etc. Then highest salary in another department starts on higher value but still fine as it is lowest rank in that department. But the problem is I now cannot do a filter based on 1-10. Do I need to update the RANK formula or can I somehow come around this with a boolean formula?

Best regards,

Johan

Accepted answers

ChrisAHeathcote

Try adjusting the RANK formula to something like;

=RANK(Value to Rank, DESCENDING, SEQUENTIAL, TRUE, PARENT(ITEM(E2 List)))

It is the last part that should direct the ranking to restart for each department.

All comments

VIGNESH.M

Hi Johan,

You have to Rank the Salary by the department(L1) to start over the ranking for each department.

In the system module, first find the L1 of each employee and use it for ranking.

The formula will look like this,

RANK(Salary, DESCENDING, SEQUENTIAL, TRUE, L1)

Check the Rank function in Anapedia for more detail.

https://help.anaplan.com/en/4f94f2e7-e7d9-4bae-ba6f-2b872e8d9189-RANK

Regards

Vignesh M

JaredDolich

@johan.marketoft

Great use case!! Adding to @VIGNESH.M point, I did something similar, where I only wanted the top department for each category. Here's how it looked.

This is the final chart. I only want to see the top group in each category.

Here's the module that powers the grid: Note I use rank but at the category level, so each category gets its own ranking of groups. Then I just use the Booleans, as you suggested.

ChrisAHeathcote

Try adjusting the RANK formula to something like;

=RANK(Value to Rank, DESCENDING, SEQUENTIAL, TRUE, PARENT(ITEM(E2 List)))

It is the last part that should direct the ranking to restart for each department.

LethargicAnalyst

NO CODE APPROACH - FRONT END NUX

No need to use the Rank function as line item, come to the front-end dashboard and open page builder in NUX.

Open the model you want to rank and sort the number line item directly engaging descending sort, disengage any filter to that line item incase if active. then sort the number the way you want and save the change. Vola !

In dashboard you might notice something like an arrow mark in pic below, it means sort is engaged and disable unsort option for end user.

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…