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


CustomersSales_A31 :



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