Hi there,
I have a matrix which has a column group and a column group which displays the report like this:
---------------------------------------------------
|_____|Population_________________________________|
|_____|_GROUP1______________|Group two____________|
| |region1|region2|Total|region3|region4|Total|
|stat1|1000 | 39909 |49909|50000 | 38237 |88237|
and so on........
I am unable to use the sigma total for each group in regions above. But it doesn't allow me to add a total right next to the data column of regions, instead the total comes next to GROUP1 and group 2
I want a total for each ROW and COLUMN group.
I am perhaps not grouping it, right.
Would somebody know what is the right way to group then?
Thanks
--
I have a matrix which has a column group and a column group which displays the report like this:
---------------------------------------------------
|_____|Population_________________________________|
|_____|_GROUP1______________|Group two____________|
| |region1|region2|Total|region3|region4|Total|
|stat1|1000 | 39909 |49909|50000 | 38237 |88237|
and so on........
I am unable to use the sigma total for each group in regions above. But it doesn't allow me to add a total right next to the data column of regions, instead the total comes next to GROUP1 and group 2
I want a total for each ROW and COLUMN group.
I am perhaps not grouping it, right.
Would somebody know what is the right way to group then?
Thanks
--