hi all,
i got a table which shows me the number of transfers of a store on everyday day together with the summed amount the store gained. my table looks like this:
store day transfers amount
1 1 1 2.50
1 2 5 3.50
2 1 2 1
and i want to put it in a report like this
store monday tuesday
1 1 / 2.50 5 / 3.50
2 2 / 1
i tried with a matrix but the the result wasnt satisifiying. the best one looked like this:
store monday tuesday
1 1 / 2.50
1 5 / 3.50
2 2 / 1
anyone can give a solution or atleast some hints?
drop store to the row group and day to the column group should satisfy your need.
No comments:
Post a Comment