For the statistical price&spending/customer add also the difference = profit.
The customers should be ordered by the price.
The price should be calculated for all the trainings of each customer for the selected year or the selected month of a specific year.
Use a top 20 and add pagination if this is easy, if not, just add them all and via resizing should be ok for a limited number of customers..
For the statistical price&spending/customer add also the difference = profit. The customers should be ordered by the price. The price should be calculated for all the trainings of each customer for the selected year or the selected month of a specific year. Use a top 20 and add pagination if this is easy, if not, just add them all and via resizing should be ok for a limited number of customers..