Top N of a measure

[Kratos_ZA]

Hi all,

Kindly assist me with with a Top N and a Bottom N measure for my YTD measure:

I have a list of Major areas and the YTD Sales or MTN Gross Conns.

I would like to Rank or get the Top 10 and Bottom 10 Major Areas based on the MTN Gross Conns measure.

Please assist:)

[Greg_Deckler]

@Kratos_ZA So one method would be to expand the Filters pane. Select the drop down for MAJOR_AREA_NAME and change to Top N. Then enter how many and then drag your MTN Gross Cons measure into the By value field well.

[Kratos_ZA]

@Greg_Deckler Thanks buddy! And the Bottom N? Also looking at bottom 20 Major Areas? 

[Greg_Deckler · Accepted solution]

@Kratos_ZA Same thing but in the "Show items" dropdown choose Bottom instead of the default Top.

[Kratos_ZA]

@Greg_Deckler Thank you so much bud! Apologies for the silly question:)

[Kratos_ZA]

Thanks buddy! And the Bottom N? Also looking at bottom 20 Major Areas?