5 Replies Latest reply: Dec 19, 2014 2:24 PM by Ama Domevscek RSS

    Dimensions

      Hello

       

      I have two dimensions

      BMI YEAR

      BMI WEEKNR

       

      Expression sum(sales).

       

      So when i select in box year 2014 i see the sum(sales) for each week.

      I have a slider based on KPI Bruto (-10% , -5%, 0%, 5%, 10%)

       

      Now i am looking for the formula that

      shows the selected sum(sales) for the selected year minus 1 and then multiplied by the KPI Bruto.

       

      Example

      Week 10 Year selected 2014, sum(bruto) 100 shows point 100 for weeknr 10

       

      other value should be sum(bruto) for week 10 for year 2013 multiplied by KPI Bruto

       

      Please help me with the formula.