a) Should I try to order the actuals and budget tabels so they look the same and than merge them, or is it best to keep them separate?
b) I see in the video “setting up complex videos” that you make a new table for countries. But you have made the budget from the actuals, so you will have the same countries both places. But what if we have budgeted with a country that don’t exist in the actuals, what will happend then? How should I do to create a tabel that I am sure containing all countries from both actuals and budget?
c) I have my actuals and budget data on a monthly level. Can I then use the date tabel on a monthly level if I, as with the countries example above, create a new table so it only contains the value/name (month) one time?