Sum of Columns while using matrix type of reports
RS Version ?
Thanks .Rajkumar Yelugu
February 26th, 2011 5:48am
Hi,
Please check if steps given below help you.
1. Add a matrix control
2. Drag the cateogry to the rows in matrix
3. Drag the state to the columns in matrix
4. Drag the city to the columns in matrix and position just below the state; drop the field when you see a blue color handle appearing below state. This would make the city a child group of the state.
OR
Drag the city field to the columns group (that appear in bottom of the designer when matrix is selected) and place below state.
5. Drag the No of orders field to the data in matrix
It should now give you the desired result. Hope this helps.Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
BH
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 6:57am
Hi Guys,
I am using SSRS and have developed a report with columns like matrix here is what I have developed
Category
California
Arizona
Newyork
Texas
Ohio
Total
SFO
San Diego
Los Angels
Phoenix
Tucson
NYC
Buffaloe
Albany
Manhattan
Dallas
Houston
Austin
San Antonio
Cleveland
Columbus
Cincinnati
Clothes
2
3
1
4
6
2
3
1
1
2
3
1
3
3
1
4
Toys
0
1
3
2
1
3
3
4
4
1
0
3
7
1
0
3
Jewellery
1
0
1
2
0
2
0
0
1
3
2
1
0
2
0
0
Shoes
2
0
1
0
3
1
0
2
1
0
1
2
2
1
2
4
Currently I am bringing the report of No.of orders for different category for different locations by using group by statement in query and matrix type report in ssrs
here is the query I used
Select O.Category, O.State, O.City, Count(O.OrderNum) from Orders O Group By O.Category, O.State, O.City
and Here is what I want to acheive I want to add every column and every Row at the end, and I also want to get a grand Total
Category
California
Arizona
Newyork
Texas
Ohio
Total
SFO
San Diego
Los Angels
Phoenix
Tucson
NYC
Buffaloe
Albany
Manhattan
Dallas
Houston
Austin
San Antonio
Cleveland
Columbus
Cincinnati
Clothes
2
3
1
4
6
2
3
1
1
2
3
1
3
3
1
4
44
Toys
0
1
3
2
1
3
3
4
4
1
0
3
7
1
0
3
36
Jewellery
1
0
1
2
0
2
0
0
1
3
2
1
0
2
0
0
15
Shoes
2
0
1
0
3
1
0
2
1
0
1
2
2
1
2
4
22
Total
5
4
6
8
10
8
6
7
8
6
6
7
12
7
3
11
117
Please Help me I am new to reporting services
Thanks in Advance
February 26th, 2011 7:03am