I have a budget file and a actuals file. Sometimes it can be client name in actuals and not in Budget (and the other way around). How should I do make a column/table containing all clients name? And also only One time.
My actuals is containg time as 201803 as 2018 March. It can connect to the date table provided here at DNA. But if I want to sum sales per year it does not work. Why? Do I have to split it out per day or should it work even if my lowest level is per month?