Hi , I need to have 2 matrices in my report.
########Matrix 1 is as follows#######
! C1 - C2 - C3 - C4
-------------------------------
11/2/2011 ! 1 - 4 - 7 - 10
11/3/2011 ! 2 - 5 - 8 - 11
11/3/2011 ! 3 - 6 - 9 - 12
-------------------------------
TOTAL ! 6 - 15 - 24 - 33
########-Matrix 2 should be#########
!C1 - C2 - C3
--------------------------------
2011 !6/33 - 15/33- 24/33
basically individual total of all columns (C1,c2,c3) are divided by total of one last column that is C4
How can I achieve the desired values for Matrix 2. Thanks.