This is my data
Product Name Quantity SaleDate
A 2 2016-01-01
A 3 2016-02-01
B 5 2016-02-01
C 7 2016-02-02
A 6 2016-02-02
A 2 2016-02-05
B 15 2016-02-06
C 10 2016-02-07
Now I want to create a report like this:
Product Name Quantity SaleDate
A 13 2016-02-05
B 20 2016-02-06
C 17 2016-02-07
Quantity = SUM(Quantity) for every product
SaleDate = Max(SaleDate) for a product
How do I group it by product and also is there a way where I can get the max date? Since this is my first Crystal report please explain it with steps.
IP Logged
