topic Re: TOP 10 values in descending order in App Development

TOP 10 values in descending order

aditi_haldule — Wed, 17 Mar 2021 06:36:01 GMT

Hi ,

I want to show a table showing top 10 account names with respect to the revenue generated by them.

so currently I'm showing a few columns in the table as- account name, revenue, region,etc.

I want to show only top 10 rows that generate the max revenue from these that too in the descending order. how do i do that?

PradeepK — Wed, 17 Mar 2021 15:40:15 GMT

You can create calculated dimension using Aggr() and Rank() functions to get top N revenue generating accounts.

Refer to this code template and disable "Include Null values" option

Aggr( if(Rank(Total <Measure>) <= <Top n> , <Filter DIM> ) ,<All DIM List> )

Below are few examples for some real world scenarios

Simple case:

Aggr( if(Rank(Total Sum([Total Sale Amount])) <=10 ,Customer ) ,Customer, Region )

Duplicate case:

= Aggr( if(Rank(Total Sum([Total Sale Amount])) <=10 ,Customer ) ,Customer, Region ,SalesRepresentative )

aditi_haldule — Thu, 18 Mar 2021 04:46:02 GMT

Thanks a lot! Will try this