Partitioned Rank by multiple dimensions

[Matt_M]

Hi Community,

My ultimate goal is to only show the top N lines on a map for each group.

My approach is to define a rank variable and use that to select the top N to filter in the map view.

I would like to create a rank variable that ranks a subset of the table based on multiple dimensions (attached) and shown below. Rank is partitioned across the "Year", "Quarter" and "Cluster" variables

I have tried two forms of the rank function:

1. rank(sum(pax_count)), which produces 1 for every row
2. aggr(rank(sum(pax_count)), 'Year') produces nulls

How can i define a rank variable partitioned across multiple dimensions? 

Thanks for any help

[Frank_S]

Perhaps what you need is the following to achieve your objective?

• Grouping measure data into ranges