I have some problems while creating report using Report Studio.
My crosstab might look like this
Province Shop Brand Measure 1 Measure 2
Province 1 10 A 1 2
B 2 3
C 4 5
Province 2 14 A 2 5
B 2 4
C 3 2
And I want to add a total rows, Group by Brand, look like this
Province Shop Brand Measure 1 Measure 2
Province 1 10 A 1 2
B 2 3
C 4 5
Province 2 14 A 2 5
B 2 4
C 3 2
--------------------------------------------------------------------------------------------------------
Total 24 A Sum(measure1) sum(measure2)
B Sum(measure1) sum(measure2)
C Sum(measure1) sum(measure2)
I have finished the report without total rows.
Can anyone help me how to create the total for this report?
Appreciate any help !