Forum Discussion
Linking budgeted data to actual
Hi all, In order to create a functioning dashboard for my department, I am looking to link my actual revenue to the budgeted revenue, so that I can give an overview of whether we reached our budg...
Hi Dale,
First of all, thank you so much for your detailed assistance!
However, my tables do not look like the one you showed in your pictures.
As stated, my columns are the dates, with the only exception being the first column which consists of the different sources of revenue.
I have imported this table directly from Excel after adjusting a few minor things to make it easier to work with.
The budget (and actual) data looks like this: (note that I removed the data and name of the business for privacy's sake)
Hope this helps!
