User543160537 posted
Hi,
I am trying to develop matrix report in below format, But I need to find the average of rating and yes/no options columns wise and rows wise.
For ex: I need to know form rating at the bottom of the row and "ADB" column rating and yes/no at that column end with Average of rating and Y/N.


FORM 
Average Rating 
YES/NO 
FORM 2 
Average Rating 
YES/NO 
AvG Rating 
MIN CHECKBOX SELECTED 
max(Y/N) 
ABC 
ADB 
x 
2 
y 
x 
5 
y 
3.5 
A 
Y 
WER 
x 
3 
N 
x 
4 
N 
3.5 
B 
Y 
QWE 


N 


N 

C 
N 
ADB 









DFG 









CVB 
x 
1 
Y 
x 
3 
Y 
2 
C 
Y 
POI 
x 
1 
N 
x 
1 
N 
1 
C 
N 
MKI 


Y 


Y 



OIU 
x 
4 
Y 
x 
4 
Y 
4 
D 
Y 
GYT 
x 
2 
Y 
x 
2 
Y 
2 
D 
Y 

























Avg(Rating) = 2.16 
Max(Y/N) 
Avg(Rating) = 3.16 
Max(Y/N) 



can some please help me how to generate report is SSRS.
Thanks
Sree