I have question on two tables. I have one table that has budget and actual sales data for year with some dimensions and i have another table in different file which has forecast for the present year. now I have to create a dashboard using these two files.
When I think of joining these two tables then I think there will be an issue because second table has a few dimensions but not all so it will give me null values. ANY THOUGHTS ON IT???
