6 Replies Latest reply: Jan 10, 2012 8:50 AM by Stefan Wühl RSS

    Matching an Existing Excel report

      I have a mysql database which has actual & budget figures for each week for specific KPI's.

       

      I want to try to replicate an existing excel spreadsheet report where the KPI's are listed vertically and the actual & budget figures are verticaly along side them.

       

      KPI     Actual     Budget     Variance

      1          100          110          10

      2          50          100          50

       

      and then colour code the variance etc.

       

      Is this possible?

       

      I want to do this as a starting point because the users are used to this format, and then craete a new Dashboard report with the same data to show them what can be done.

       

      thanks in advance for any help

       

      Dave