Hi all,
I have a query with MOP (mode of payment) column, like.
Cash 500
Cash 300
GCash 400
Bank 300
Bank 600
Cash 300
Bank 300
GCash 200
Now, this one i could not figure out how to make a total for each mode (cash, gcash, bank) in separate column.
I have a query with MOP (mode of payment) column, like.
Cash 500
Cash 300
GCash 400
Bank 300
Bank 600
Cash 300
Bank 300
GCash 200
Now, this one i could not figure out how to make a total for each mode (cash, gcash, bank) in separate column.