S
SthOzNewbie
I have a sales records table with the following fields - FiscMonth, CustNo,
Product, SalesQuan, SalesVal, ShipDate.
One of our customers would like their sales data summarised as follows -
Product, Tot Jan Sales, Tot Feb Sales, Total Mar Sales etc., YTD Sales,
Price Per (I was going to use the SalesVal / SalesQuan from most recent
transaction to calculate this)
Any help would be appreciated
Product, SalesQuan, SalesVal, ShipDate.
One of our customers would like their sales data summarised as follows -
Product, Tot Jan Sales, Tot Feb Sales, Total Mar Sales etc., YTD Sales,
Price Per (I was going to use the SalesVal / SalesQuan from most recent
transaction to calculate this)
Any help would be appreciated