I need some help, this is my first matrix report. My stored procedure
pulls data in the following format.
Internal_User user_id expense_user_id Amount
category Period month year
Doe, John 99 1234567 385.7900
Airfare May-2007 5 2007
ETC.
I have the matrix set up currently with Row Groups on Internal_user
and Category, and column group on Period. This looks good, what I need
though is a total by internal user for all the categories. Then I
need a category total in the last column. When I try to do a subtotal
on the Internal_User rowgroup it says total, but only spits out the
first category value.
Heres what it looks like
Jan-2007
Feb-2007 Mar-2007 Apr-2007 May-2007
Doe, John
AirFare
385.79
Entertainment 1587.22
556.2 537.39 1996.30
Taxi 100.00
100.00 200.00
Total 1587.22
556.2 537.39 1996.61 358.79
I want the total like for Jan-2007 for example to be 1687.22. I
appreciate any help.Disregard...found the answer.
No comments:
Post a Comment