5 Replies Latest reply: Jun 18, 2015 10:20 PM by jagan mohan rao appala RSS

    Formula for summing a value of a dimension

      Hi, I want to show the sum of a value of a dimension in a KPI. I have created the following hypothetical example to illustrate.

       

         

      Sales
      North956.376,34 €
      South805.544,99 €
      East686.844,42 €
      West581.089,77 €
      * Dimension: Sales
      * North, South, East, West are dimensional values

       

       

         

      North
      John315.604,19 €
      Bob191.275,27 €
      Billy239.094,08 €
      Lincoln210.402,79 €

      * Breakdown of North

       

       

      What would be the best way to show the total sum of all sales in North, i.e., 956.376,34 € in the front end? My formula is

      sum(if(Type='ComponentCVaR',Type,null())) but it is not working...

       

      Thank you.