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

    What if Analysis for Net Sales Forecast



      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