SSRS Matrix Summary Expression

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)

SSRS Matrix Summary Expression

Author

Topic

samanthab
Starting Member

10 Posts

Posted - 2009-03-16 : 13:42:42

Im New to SSRS, im using the 2005 version. please bare with me as i try 2 be as detailed as possible

I have created a pivot table with drilldown options. I have 6 columns that i would like to reduce to 3. The problem is they are related. the first 3 columns are values for 3months, 6months, 12months and the last three are the sums of the number of times each value goes above a certain level.

There are three levels Green, Amber and Red (lowest to highest)

I would like the toplevel to just have just the colour of the highest level value (whatever that may be)

I.e. Green is overtaken by Amber, and Amber overtaken by Red.
I dont want to see the values until i drilldown to the thrid and final level.

So basically I will just be looking for Red and Green colours at the top level, Then Drilldown for more options, which will again be in colour- then finally the 3rd level will have the value.

Is this possible?

any ideas would be appreciated

Thanks

-------------------
More Info

These are the expressions I have for the Last three columns -which sum the 1st three columns

=iif(Sum(Fields!RAG_Used_PC_R.Value)>0,"Red","Transparent")

=iif(Sum(Fields!RAG_Used_PC_R.Value)>0,"Transparent", (iif (Sum(Fields!RAG_Used_PC_A.Value)>0, "Orange","Transparent")))

=iif(Sum(Fields!RAG_Used_PC_A.Value)>0 OR((Sum(Fields!RAG_Used_PC_R.Value)>0)), "Transparent", (iif (Sum(Fields!RAG_Used_PC_G.Value)>0, "Green","Transparent")))

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-16 : 13:45:18

sorry cant get much idea from explanation. try to create a screenshot of what you want and post it in some shared server and put the link here so that ppl can understand what you mean

samanthab
Starting Member

10 Posts

Posted - 2009-03-16 : 14:13:30

Sorry, i know its abit tricky to explain

here is a screenshot of how it is at the minute

I Was wondering if it is possible to still 'use' the values from the frist 4 columns but perhaps hide them ( or if there is another way great!)

so use the values to work our of the box is Red, Amber or Green.

Also i would like the boxes to just show the colour and not the number.

When i drilldown on the LHS twice i would then like to see the corresponding values....

this any clearer?

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-16 : 14:15:21

sorry..i cant view the image

samanthab
Starting Member

10 Posts

Posted - 2009-03-16 : 14:17:54

woops sorry