I looking to make a view that is similar to the sales report but struggling to get my head round it, or weather it's actually possible.

I would like to have a single row for each day of sales, with a column showing the products sold and the number of each product sold and be able to filter it by order status and payment method.

This would mean I would have 3 columns, Date, Products Sold and Total Revenue, but I'm struggling to find a way to list all products sold on a particular date in the same row.

Also with the payment method I'm using Uberpos which generates a payment method of pos_cash if the payment type is cash but it is not available when you expose the payment method filter. Is this something that needs correcting in Uberpos or this module?