Monthly Sales Matrix by Year
Hi, I am wondering if anyone can help me create a layout which displays monthly sales data by year in a matrix format.
I have a table where I enter in customer name, product type, number of items sold and date sold.
I would like to create a matrix style report where across the top it displays the months of the year and down the left side it displays the customer names. It seems easy to make this type of table in excel but I am having trouble making it in filemaker.
I imagine that I somehow need to create 12 different calculations for each month of the year. These calculations will pull together all the corresponding dates for the month from the date sold field. However, I dont have much experience with calculations and can't figure out how to do this.
Does anyone know?
I have included a picture of the kind of matrix I am hoping to produce.
Thaks in advance