The basic premise is to group customer sales into buckets. Unfortunately, cannot provide data as it is customer data, however, it is based on the following:
- Group sales into buckets based on the following ranges for customer:
- 30k to 50+
- 20k to 30k
- 10k to 20k
- 5k to 10k
- 1k to 5k
So the end user can select a list for example, Jan-2017, and the sales buckets will reflect sales in each bucket based on customer.
It's basically the opposite of the calculation I posted earlier.