Top Customers

[dusasuman]

Hi Community,

I need to show customers count in a text object where the sales of customers is more than overall avg sales per customers.

Also need to show the same customers list in a table with their sales..

Please help me with solution

[tresesco]

Could help us providing a sample qvw to work with and explain your expected output against your data sample?

[dusasuman]

Please look at sample data

[Anonymous]

=Sum(if(Aggr(Sum(Sales),Cust)>Aggr(Avg(TOTAL Aggr(Sum(Sales),Cust)),Cust),1))

[shiveshsingh]

Hi Suman

Please create one variable as vAVG = SUM(Sales)/Count(Cust)

Text box SET analysis.

=Count({<Sales={'>=$(=vAVG)'}>}Cust)

[tresesco · Accepted solution]

PFA

Expression in chart :

=Sum(if(Aggr(Sum(Sales),Cust)>Aggr(Avg(TOTAL Aggr(Sum(Sales),Cust)),Cust),Sales))

Expression in text box:

=Concat(if(Aggr(Sum(Sales),Cust)>Aggr(Avg(TOTAL Aggr(Sum(Sales),Cust)),Cust),Cust), ',' )

[Anonymous]

... this solutions is not weighted by customer... we don't know what Suman needs exactly...

[dusasuman]

Thanks for your reply,

I have attached the sample file with source data and out put needed. Please find the attachment.. Output sheet is the desired requirement

[Anonymous]

did you have a look at the solutions above?!?

[dusasuman]

Yes Just looked in to it, Your solution is correct.. Appreciate your help .. Thanks!!