Hi,

I need some help on how i can do this in crystal report, I would like to get each item number and based on their first invoice transaction, i would like to get the quantity sold for the first month, second month and third month in columns.

For example: 

Item Number: "A" first invoice sold in 3/15/2022,

The output would be:

Columns: Item No: A, First Month Qty Sold: 3, Second Month Qty Sold: 80, Third Month Qty Sold: 50

Basically i need to find out how many we sold during the first 3 months since the first transaction of each item number.

Thank you!