8 Replies Latest reply: Feb 22, 2013 8:07 AM by Selvakumar S RSS

    What if Analysis for Net Sales Forecast

      Hi,

       

      I have 5 year sales data. Now i want to do what if-analysis for the same.

       

      For Example:

       

      If 2013 jan net sale is 500 and feb is 2000.I used one slider form (-20 to 20) as vPrice.

       

      I took month in dimension and expression as Sum(NetSales)*vPrice

       

      Now, 2013 only has data for jan and feb but when i use the slider, it should automatically take the last year netsales amount and multiply by vPrice automatically till december.

       

      example: Feb Net sales is 2000, so for march Sales= 2000*vPrice, April Sales =2000*vPrice ...Dec Sales = 2000*vPrice

       

       

       

      Thanks,

      Selva