tricky summary problem?
using 8.5 on mac os 10.5, progressing newbie..
I have a bunch of raw sales data with individual records in the form:
MOP (Mastercard, Visa, Cash, Cheque or EFTPOS)
Event (one of up to ten events)
what I'm wanting is a summary report, giving me a listing like:
TransDate | Event | Total M/C | Total Visa | Total Cash | Total Chq | Total EFT | Day's total for that show | Day's Grand Total
is this a Filemaker possible scenario?
not sure how to go about it, any help appreciated. (I know I can do it in Excel with quite a bit of filtering, but would like it to auto-run in FM)
thanks in advance