Filter Totals by Payment Method

[rezman]

Hi,

I have a rather complex POS system I have created, and I am stuck in the creation of a certain report. I know there must be a simple answer, but for the life of me I can't quite get it.

The report I wish to generate is a total income collected. And, I need to break this up by cash, check, charge, gift certificate.

The other reports start off with a date sort, so that is in place. In the order page I have subtotal, subtotal after discount, tax, total. So these fields would obviously be used for the calculation.

I hope I've given enough information. Any help would really be appreciated.

Thanks again,

Stephen