I have a content type, "transaction" setup like this:
Name of item | Size (text field) | Payment (text field)
I need a view to display:
Name of item | S | M | L | Total
Item 1 | $1.50 | $0.00 | $0.00 | $1.50
Item 1 | $1.50 | $2.00 | $0.00 | $3.50
Item 1 | $1.50 | $2.00 | $5.00 | $8.50
Item 2 | $0.00 | $2.00 | $5.00 | $7.00
Item 2 | $0.00 | $2.00 | $5.00 | $7.00
Then I need a way for it to merge the payments together per item sold, for instance:
Name of item | S | M | L | Total
Item 1 | $4.50 | $4.00 | $5.00 | $8.50
Item 2 | $0.00 | $4.00 | $10.00 | $14.00
Is there a way to do this?
I haven't found a module out there that will do this.
Views Calc will put a row in the bottom providing a sum of the totals but I need a sum of each row (in the column to the right) and I don't know what module will merge the data... :/
Thanks in advance for the help!
Phil