Bottom 5 sales

[#1]

Hello ,

i am using this expression to find comparison between Actual Margin and Quoted Margin sorted for  5 highest revenue  giving account using this expression

If(Aggr(Rank(SUM(Revenue),4),Account)<=5,Account), however i am trying to calculate same thing for  bottom 5 revenue ,

please suggest

[Anonymous]

Hi Prashant,

try:

=If(Aggr(Rank(-SUM([Total Invoiced Revenue]),4),AccountName)<=5,AccountName)

[nikhilgarg]

Hey neetha,

Cann't we do like this that:

Select AccountName as Dimension

Put below expression :

Sum({<AccountName = {"=Rank(Sum([Total Invoiced Revenue]))< 5"}>}[Total Invoiced Revenue])

is this approach right ??

[Anonymous]

Depending on requirement we can use this

[nikhilgarg]

Ohk ,

but actually it is not giving the correct result

[Anonymous]

Its grouping the Total Invoiced Revenue data and giving results for account  name

[nikhilgarg]

Ohk,

Then how to get the last 5 account names based on Total Invoiced Revenue data ??