2.9 Grouping: sum

 

Calculate the total sales amount of each product based on the following daily sales table.

Date Product Sales
2022-01-01 00:00:00 Cereal 98.0000
2022-01-01 00:00:00 Meat 174.0000
2022-01-02 00:00:00 Cereal 168.0000
2022-01-02 00:00:00 Meat 167.4000
2022-01-03 00:00:00 Cereal 1696.0000

SPL script:

A
1 =T(“DailySales.xls”)
2 =A1.groups(Product;sum(Sales):Sales)

Execution result:

Product Sales
Cereal 309998
Meat 174645