13 Replies Latest reply: Apr 27, 2016 8:56 AM by Stefan Wühl RSS

    Using multiple set modifiers in a set expression

    Sowmya M

      Hi community,

       

      I have a viz with:

       

      dimension: year

      measure: sales broken down by product type (the colors represent different product types)

       

      Chart 1:

      sales by time.PNG

       

      below that i have a KPI viz that tells me sales for 2015 & 2014

      Chart 2:

      KPI sales.PNG

       

      How do i create a set modifier for 2014 and 2015 sales in the KPI chart(Chart 2) such that only a product segment selection from chart 1 above affects it but not the year selection..

      The year should be fixed at 2014 and 2015 in Chart 2, but if I select the blue segment from anywhere in Chart 1 it should give sales for blue segment in 2014 and 2015 in Chart 2