how to get the product Average selling price monthly with FMP
I have the Point of Sales list for total year, the list have the following field.
customer, product, ship_month, ship_qty, ship_amt,
I want to run a report , it shows the product average selling price monthly.
I define the "calculated field" , such as ship_qty total, ship_amt total. I must get every product Monthly Qty and Monthly ship_amt. but I did not know how to get the ASP, if I use another New field calculate it, (ship_amt total/ship_qty total), it return the result that shows total years sales out/ total years qty.
Do you have good idea to me. and I want to make a chart with the Average selling price.