I am new to matrix reporting, andam trying to recreate a piviot table report with counts of number of documents by location, pivoted against doc type (horizontal axis).
I have created this ok but there are two outstanding issue; firstly i cannot get the group total to diplay at the bottom of my report detail, only below the column header (I would have thought this would be a simple drag and drop!).
The second thing i need to add is another footer grouping the document types together with a sub total count of document in each group (see below):
Document Types
Location A01 A02 A03 B01 B02 B03 Total
London 22 3 0 25
Houston 06 5 0 11
Mumbai 15 0 6 21
Total 42 8 6 x y z 48
Group Mechanical Electrical
Grp Tot 56 x+y+z
Any help or direction towards any good tutorials would be much appreciated.
Andrew Murphy
I have created this ok but there are two outstanding issue; firstly i cannot get the group total to diplay at the bottom of my report detail, only below the column header (I would have thought this would be a simple drag and drop!).
The second thing i need to add is another footer grouping the document types together with a sub total count of document in each group (see below):
Document Types
Location A01 A02 A03 B01 B02 B03 Total
London 22 3 0 25
Houston 06 5 0 11
Mumbai 15 0 6 21
Total 42 8 6 x y z 48
Group Mechanical Electrical
Grp Tot 56 x+y+z
Any help or direction towards any good tutorials would be much appreciated.
Andrew Murphy