Report of Customers Sales is created using group by CustomerType, SalesYear
Summary of number of records ( count(*) ) and sum(SalesAmount) is created.
Data can be filtered e.g. data only for SalesYear=2018
and group-by report is created from filtered data.
Source Table = CustomersSales_A31
Report Table = CustomersSalesReport
Filter data as needed : e.g. SalesYear=2018 can be checked to filter data for year=2018
Result of CustomersSalesReport :
For Any Question please Contact MyDataOrganizer