Okay, but if I remove the PRODUCTID then the query just returns the total sales for the date broken down into CASH, CREDIT CARD, BANK TRANSFER.
I need to get those three totals (CASH, CREDIT CARD, BANK TRANSFER) for rooms, laundry, Taxi etc for each date