Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
SUM(Aggr(IF(Rank(SUM(Sales))<=3, SUM(Sales)),Product, EmployeeName))
Try this:
SUM(Aggr(IF(Rank(SUM(Sales))<=3, SUM(Sales)),Product, EmployeeName))