May 12, 2009 at 9:04 am
Hi to everybody,
I have got a problem with matrix. I have a report looks like:
May
1 2 3 4 5 6.....
-------------------------------------------------------
Person1 Salary | 10 3 ..................
Foods | 5 11 ..................
. | 0 0
. | 0 0
Total | 15 14 ..................
--------------------------------------------------------
Person2 Salary | 43 5 ..................
Foods | 0 23 ..................
. | 0 0
. | 0 0
Total | 43 28 ..................
I want to calculate the totals for each person according to each day of the month. But i cant find the expression for the field Total in order to get these results. Can anybody help me please? Thanks for any reply.
PS: If more info needed to solve, please inform me.
PS: You can look at the attachment to see the report in exact order.
May 12, 2009 at 2:21 pm
I would just use the SUB TOTAL for that person grouping or use INSCOPE function.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply