Budget vs Actual Reports: how to make one?
I have a number of KPIs and have budgeted and actual values for each. I want to make a table with 4 columns: the KPI name, the budgeted value, the actual value and the deviation. Each row should be a different KPI.
Bonus: If the 3 columns (budget, actual, dev) could be repeated for different time periods (for example, weeks) it would be even better!
Something like this:
Can someone help?
Thanks in advance.