12 Replies Latest reply: Dec 17, 2015 4:08 AM by jhonatan ben ami

# SALES REPORT: TOP CUSTOMERS

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

• ###### Re: SALES REPORT: TOP CUSTOMERS

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.

• ###### Re: SALES REPORT: TOP CUSTOMERS

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

• ###### Re: SALES REPORT: TOP CUSTOMERS

i did it and got this....

• ###### Re: SALES REPORT: TOP CUSTOMERS

Max( total aggr( NIS_TOTPRICE, CUST_CUSTNAME) )

• ###### Re: SALES REPORT: TOP CUSTOMERS

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

• ###### Re: SALES REPORT: TOP CUSTOMERS

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

• ###### Re: SALES REPORT: TOP CUSTOMERS

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.

• ###### Re: SALES REPORT: TOP CUSTOMERS

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

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

• ###### Re: SALES REPORT: TOP CUSTOMERS

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.

• ###### Re: SALES REPORT: TOP CUSTOMERS

you are absoultliy wirght but for some reason it only gives me sorting the customer name and not the sales....

• ###### Re: SALES REPORT: TOP CUSTOMERS

Does it allow you to sort the Customer 'by expression' .  Then you can re-enter the same measure expression.

• ###### Re: SALES REPORT: TOP CUSTOMERS

thank you all!! the default error was due to the fact i took a pivot table and not a flat table