Qlik Sense product,Employee wise Top 3 sales amount need to show in Text Object

[joshibabu_are]

Hi Guru's,

i want to show top 3 sales amount in Text Object.

i want to aggregate amount  on employee,Product.

actual amount to show in object is:31801.07

How to write expression?

Thanks,

Joshi

[sunny_talwar · Accepted solution]

Try this:

SUM(Aggr(IF(Rank(SUM(Sales))<=3, SUM(Sales)),Product, EmployeeName))