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!