Hi i have below scenario and i want show top 10 spends in bar chart

[#1]

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.

[Anil_Babu_Samineni]

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])

)

[beck_bakytbek]

Hello Naveen,

try this:

if(aggr(rank(Sum(SpentAmount)), CustomerName) <=10, CustomerName, 'Other')

i hope that helps

beck

[narayanamsn]

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