# Select Multiple values from a parameter in a different matrix

### Question

• Hi,

I have 10 KPI's and for all the 10, a new matrix is made, as the user requires it to be view all 10 differently.

I am trying to use multivalue parameter.In the matrix created

under FILTERS the following expression used:

1st matrix  =Parameters!KPI.Value(0),

2nd matrix =Parameters!KPI.Value(Parameters!KPI.Count-1)

3rd matrix =Parameters!KPI.Value(Parameters!KPI.Count-2)...so on

under HIDDEN the following expression used:

1st matrix  =FALSE

2nd matrix  =iif(Parameters!KPI.Value(Parameters!KPI.Count-1)=Parameters!KPI.Value(0),true,false)

3rd matrix =iif(Parameters!KPI.Value(Parameters!KPI.Count-2)=Parameters!KPI.Value(0),true,false)...so on

The above is working for n & n-1 matrix but not for the rest.

Below is the representation of the matrix used.

 KPI1 Act Bud MTR YTD YTD YTD 2012-13 2012-13 2012-13 BU1 1 2 2 BU2 2 3 3 BU3 3 4 4 KPI2 Act Bud MTR YTD YTD YTD 2012-13 2012-13 2012-13 BU1 2 3 3 BU2 3 4 4 BU3 4 5 5

Regards

Archana

Monday, July 01, 2013 10:28 AM

### All replies

• The above is working for n & n-1 matrix but not for the rest.

Hello,

Can you post more details about your issues? Did you means that the Hide expression is not work for the rest?
It seems that you create multiple Matrix data regions and filter the data in Matrix based on the different value of the parameter.

Please post a screen shot of the report, it benefits us for further analysis.

Regards,
Fanny Liu

Fanny Liu
TechNet Community Support

Wednesday, July 03, 2013 7:52 AM
• Thanks for your prompt reply but I got the solution by implementing filters on dataset.
Monday, July 08, 2013 6:40 AM