2 Replies Latest reply on Jan 17, 2012 2:54 PM by Miroslav Umlauf

    Blending Actuals and Forecast and display in one row

    Miroslav Umlauf

      Hi all, attached is self-explanatory example in excel. I have Actuals (from OLAP cube) and Forecast (XLS input). Our daily report should show for each category ( i.e. Eshop) revenue by days (in columns) - if actuals available, show actuals; if actuals n/a, show forecast.

      Can do classic actuals x forecast comparison using data blending, however this 'visualization' took me this night ... and nothing.

      Thank you.