none
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

Answers

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
    Moderator
  • Thanks for your prompt reply but I got the solution by implementing filters on dataset.
    Monday, July 08, 2013 6:40 AM