Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

reporting services-display GROUP total on a matrix column

Status
Not open for further replies.

adev111

Programmer
Jul 8, 2004
44
0
0
CA
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

--

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top