HELP ADDING % of TOTAL to MATRIX

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

HELP ADDING % of TOTAL to MATRIX

Author

Topic

v_kash
Starting Member

45 Posts

Posted - 2011-12-20 : 14:00:18

Appreciate if anyone can help: We are using 2005 Reporting Services.

I have a matrix with 2 columns in it so far:
Column 1 = Fields!Region_Value.Value
Column 2 = Count(Fields!f0101_aban8.Value)

The results look like this:
Region Count

Central 155
Eastern 364
Mountain 31
Pacific 39

What I want is another column that tells me the % of total for each region. So for example, I'd like a column next to 'COUNT', and the value for Central would be 26.3%. I've researched the 'in scope', but am having problems getting it to work. Any help would be appreciated :).. Thanks fellas!

v_kash
Starting Member

45 Posts

Posted - 2011-12-20 : 14:36:36

=switch(

inscope("matrix1_Region_Value") and inscope("matrix1_ColumnGroup1"),

Count(Fields!f0101_aban8.Value)/sum(Fields!f0101_aban8.Value, "matrix1_ColumnGroup1")*100,

inscope("matrix1_Region_Value") and inscope("DataSet1"),

Count(Fields!f0101_aban8.Value)/sum(Fields!f0101_aban8.Value, "matrix1_Region_Value")*100)

I've tried that but it doesnt work! I get 0 as the value returned. HELP!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources