counting of customers that generate 80% of sales, to be evaluated for each period (month, year, etc.

[JdBernate]

Hi guys

Im having real troubles to find a solution for this situation. I would like to do a distinctcount of customers in the table of sales identifying the customers that generate the 80% of the sales. This measure should be available for every period (year, month etc)

the structure of the table:

id

date

Group

Invoice number

Invoice type

Client

Category

Sales ($)

Hope you can help me

my best regards

[Floriankx]

Hello,

can you post some sample data so we are able to copy them?

Do you have a separate customer table?

Best regards

[JdBernate]

Hi FlorianKx

Sorry i hadnt seen the notificacion of the reply.

Yes, i have a Sales table that is a transactional table and customer, zones,   etc. as master tables. Im attaching the sales table so you can see the structure.

Sales

Thank you for answer

Best regards