Sorry if this has been covered else where, but I am trying to generate a report that will give me data sorted in both the x and y axis
Eg data has to fields, Branch and Eligibility. There may be up to 30 possible entries into each field, and I want to generate a report that gives me specific count in the matrix
E1 E2 E3 .....
B1 10 8 6
B2 6 10 5
B3 11 5 0
Is there a simple way to achieve this? I know I can get them sorted in a report in the form
thanks in advance