11 Replies Latest reply: Nov 17, 2016 9:51 AM by Bill Markham RSS

    Presenting Budget & Forecast Variances

    Bill Markham

      Hi

       

      I am trying do something that at first I thought would be easy, but I can't get the solution I am after.

       

      I have attached a qvw with a sample inline data load

       

      My sample data has

      •      A dimension of Area
      •      A dimension of Type with values of Actual, Budget & Forecast
      •      Values for Hours & Money

       

      And in the script I have created an additional Cross Table of the data, as somehow I felt that would help.

       

      The need is to present in a single table a summary of Actuals, Budgets, Forecasts & Variances as columns and Area / Type as Rows formatting the Money cells with £.

       

      My real data has many Areas, more dimensions and many more metrics than just Hours and Money.  Plus I need to allow for additional Areas and metrics being added to the source data and the table handling this automatically.

       

      It needs to be a single table as beancounters being beancounters, they will want to export it to Excel.

       

      Either a script or front end solution would be fine

       

       

      Any suggestions please as my brain has gone numb ?