1 Reply Latest reply on Aug 23, 2018 4:18 PM by Patrick A Van Der Hyde

    Filtering two dimensions

    sowjanya kolluru

      Hi,

       

      I have a data with 3 columns.

      1. PRODUCT CATEGORY - Credit Cards, Mortgages, Current Accounts

      2. KRI NAME - In this we have 10 KEy Risk Indictor names

      3. KIR VALUE - In this we have 10 Key risk Indictor values

       

      I have to prepare a combo line charts.

       

      what I want to do is as below:

       

      I want to create two calculated fields KRI name 1 and KRI Name 2 with the same values of KRI Name

       

      secondly, Product category, KRI name 1 and KRI name 2  will be added to my filters.

       

      Now, when I select Product category for example, credit cards...... then my KRI Name 1 and KRI name 2 should show only the relevant KRI's for Credit cards.

       

      I select to show only relevant values, then what happens is only for KRI Name 1 the values are relevant, but for KRI name 2 is not selecting relevant values for credit cards.

       

      Even though it is showing as selected, it is not.

       

      Also when I select the credit cards, and kri name my first line gets updated, but when I select my second KRI name 2, my charts disappears.

       

      I have tried by adding my Product category to my context, and selected my KRI names 1 and 2 to be only relevant values to context, still it is not working. please help.

       

       

       

       

      what is wanted to show is as below: when I select my product category, I want to display to lines, one for KRI name 1 and second axis is KRI Name 2.  please help me if this is possible.