Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Customer Name | Spend Date | Spend Amount |
Customer A | 01/06/2016 | 11000 |
Customer B | 02/06/2016 | 2000 |
Customer C | 03/06/2016 | 13000 |
Customer D | 04/06/2016 | 4000 |
Customer E | 05/06/2016 | 5000 |
Customer F | 06/06/2016 | 6000 |
Customer G | 07/06/2016 | 7000 |
Customer H | 08/06/2016 | 8000 |
Customer I | 09/06/2016 | 9000 |
Customer J | 10/06/2016 | 10000 |
Customer A | 11/06/2016 | 11400 |
Customer B | 12/06/2016 | 12000 |
Customer C | 13/06/2016 | 13000 |
Customer A | 14/06/2016 | 14400 |
I have used below dimension and expression
[Customer Name]
max(aggr(sum([Spend Amount]),[Spend Date])), But, if a customer repeated in top 10, it is skipping the same and displaying the next non repeated entry.
Please help me to get top 10 spend entries, even if a customer repeated in top 10.
Naveen,
Try this..
Method #1
Use Flag from inline and then take the dimension - [Customer Name]
Expression =Sum({<Flag={1}>}[Spend Amount])
Updated:
Method #2
//=if(aggr(rank(sum([Spend Amount])),[Spend Date])<=10,[Spend Date])
Method #3
=avg(aggr(
if(
rank(sum([Spend Amount])) <= 10,
sum([Spend Amount])
),[Spend Date])
)
Hello Naveen,
try this:
if(aggr(rank(Sum(SpentAmount)), CustomerName) <=10, CustomerName, 'Other')
i hope that helps
beck
Hi Naveen,
I am suspecting that the Spend Date format should changed from Indian system to US (MM-DD-YYYY)
Then try again..
Regards,
Satya