1 Reply Latest reply: Aug 7, 2015 1:02 PM by Sunny Talwar RSS

    Color elements of calculated dimension

    Simon Koenen

      Hi,

       

      I have a chart with a calculated dimension including if statements

       

      e.g.

       

      [...]

      IF(

      AGGR(

      COUNT(
      {<
      data_type_key={'profitability'}
      ,version_single_key={'Actual'}
      ,%measures_key={'$(v_select_measure)'}
      ,period_year={'<$(v_select_mr_end)>$(v_select_mr_start)'}
      ,fiscal_year
      >}material_count_key
      )
      ,
      material_count_key
      ) > 50

      ,

      DUAL('>= 3.500 EUR and > 50pcs', 2)

      [...]

       

      Now I would like to color all elements with '>= 3500 EUR and > 50pcs' red.

       

      But how can I refer to a calculated dimension?

       

      Thank your for your help.

      Best

      Simon

        • Re: Color elements of calculated dimension
          Sunny Talwar

          Use this may be for the background color of your dimension:

           

          IF(AGGR(COUNT({<data_type_key={'profitability'},version_single_key={'Actual'},version_single_key={'Actual'},%measures_key={'$(v_select_measure)'},period_year={'<$(v_select_mr_end)>$(v_select_mr_start)'},fiscal_year>}material_count_key), material_count_key) > 50, Red())