I am looking to create a report that management uses as a scorecard from a flat excel to be automated within a qlikview report. I believe it will contain a lot of calculated conditions within the columns but I do not know the best way/object to display this data.
Some of the information or columns I would use would be like these below. Each of these columns would be calculated conditions I feel, but I do not know the best way to display this data in a qlikview report that would then pull and update from our fields. Any direction or guide to this would be great.
| Annual Baseline (Prior Year) | Forecaste/Goal by Month | Vari from (Actual vs Budgeted) | Current Month | Year-to-Date Actual | % of Annual Forecast | Annual Forecast |
---|
Sales | | | | | | | |
Bookings | | | | | | | |
Bookings GP% | | | | | | | |
Sales ($) | | | | | | | |
GP ($) | | | | | | | |
GP % | | | | | | | |
| | | | | | | |