Hi Bo gurus,
I want to create a report to show forecasting in webi and i want keep scroller on (dimentsions) each row if the scroller moving the value also need to change.
year country state sales upto 2011 2012 (forecasting)
2001 US 535345
2011 UK 45466
2011 IND 565656
2011 Canada 56546546
For 2012 i created variable how can i achieve forcasting based on existing 2011 values and i want to put scroller on country (for each country i want a scroller for ex: us--
) if we are moving scroller the values in 2012 should be change.