SALES REPORT: TOP CUSTOMERS

[#1]

hey evryone short questiion regarding a sale report , how do i present my top customers and my wickest customers?

[reddy-s]

Hi Jhonatan,

A scatter plot would be the best way to show it. It would be very easy to pic the outlays.

You can even go with colour coding (RAG status) to give a better visual appearance.

[JonnyPoole · Accepted solution]

Have a look a the following. 2 horizontal bars. One with top 5 and other with bottom 5

i made the min/max of the axis the same.

The measure is sum(Sales) so the max is the maximum value by customer (i have country)

Max( total aggr( sum(Sales), country) )  

and the min is similar

Max( total aggr( sum(Sales), country) )  

i also moved the axis on the top bar to the top and changed the colors

I think its a decent approach to show the top/bottom 5

[#4]

i did it and got this....

[#5]

Max( total aggr( NIS_TOTPRICE, CUST_CUSTNAME) )

[JonnyPoole]

The expression is syntactically.incorrect. The first argument for the aggr () function is a chart aggregation function like sum()

Example:

Max( total aggr( sum(NIS_TOTPRICE), CUST_CUSTNAME))

[#7]

i don't see where are u placing this expression....

[JonnyPoole]

Take a look at the bottom right part of my 2nd screenshot above. I'm.using it to.define a min or max on the X axis scale. That way the scales for both apps line up and it's useful to see how far apart the.top.customers.are.from the bottom.customers.

[#9]

Hey i used your suggestion and i am getting a table with 10 customers,

but still no getting the top/lowest ....

[JonnyPoole]

It LOOKS like you are getting both top 10 and bottom 10 in the tables. Perhaps you want to hit the 'Sorting' property on the right to ensure you are sorting by ILS Total ?  To me it looks like only the sort is missing.