Matrix and SubTotal

HI,
I have a matrix and data should look like this
The row groups are Office(Mayor)and county(A and B)and
votecount(Total). The Column groups are Party and Candidate.
Then I have a subtotal on office group.
Any suggestions how can I achieve this in my report?
Mayor Democrat
Total candidate1 Candidate2
A 60 40 20
B 80 30 50
140 70 70
But I get the result like this. I am missing subtotal on Total.
Mayor Democrat
Total candidate1 Candidate2
A 60 40 20
B 80 30 50
70 70Hi,
Did I ask wrong question? Let me know so that I can make
correction.Please some one help me out.
thanks.
rb
rb wrote:
> HI,
> I have a matrix and data should look like this
> The row groups are Office(Mayor)and county(A and B)and
> votecount(Total). The Column groups are Party and Candidate.
> Then I have a subtotal on office group.
> Any suggestions how can I achieve this in my report?
> Mayor Democrat
> Total candidate1 Candidate2
> A 60 40 20
> B 80 30 50
> 140 70 70
> But I get the result like this. I am missing subtotal on Total.
> Mayor Democrat
> Total candidate1 Candidate2
> A 60 40 20
> B 80 30 50
> 70 70