3 Replies Latest reply: Jan 26, 2018 5:18 PM by Petter Skjolden RSS

    Calculate Standard Deviation Price for last not selected dimensions

    Haidar HAJ ALI

      Hello,

       

      In my application I have calculated the price deviation as follow and it is working fine, it calculate the deviation taking into account the ITERATION I have selected.

       

      Stdev(aggr(Sum([PRICE])/Sum({<[CATEGORY]={"1"}>}[NB ITEMS]),ITERATION))

       

      The table bellow resume my DATA:

      IterationNB ITEMSCATEGORYPRICE
      IT1521000
      IT1413500
      IT231350
      IT3911000
      IT41114000
      IT5413000

       

      Here is my problem, I display always only 3 iteration in my report.  I need to calculate 2 KPI:

      - stdev for the 3 selected iterations (which is done) ex: IT5,IT4,IT3

      - stedv for the before last 3 selected iteration: ex: IT4,IT3,IT2

       

      My goal is to display both stedv to tell if the stdev was better before or no.

       

      Thanks for your help.