Need Logic help

[lalitkgehlot89]

Hi,

In given data i want to show top 3 storeid of each businessline with Netamount.

Please help me out.

Regards,

Lalit Kumar

[varshavig12]

Try using Rank()

[florentina_doga]

see attach

[tresesco]

PFA

[lalitkgehlot89]

no attached file found.

[lalitkgehlot89]

no attached file found.

[sujayrpatil]

Hi lalit ,

You can use the below condition to get top 3 net values of Businessline.

=if(Rank(aggr(sum(NetValue),BUSINESSLINE))<=3,aggr(Sum(NetValue),BUSINESSLINE))

[Chanty4u]

Please open  your thread in new tab u can able to find the attachments

[santiago_respane]

Hi, you need to create a chart, add businessline  and storeid as dimension and then use an expression like this:

if(rank(sum(NetValue))<4,sum(NetValue))

Please let me know if this helps.

Kind regards,

[HirisH_V7]

Hi,

Check this,

=IF(Rank(Aggr(Sum(NetValue),StoreID,BUSINESSLINE))<4,Sum(NetValue))

HTH,
Hirish