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