Hi, I am trying to create a link table but does not seem to get it right.
I have Sales Classifications in my budgets per fiscal year per month per branch but don't have any sales that was done and need to create a link table to show all values regardless of where there was a sale.
My dimension is my sales classification (for my actual) and not my sales classification in my budget.
When looking at the below table i have clients that was budget but there was no sales done.
Re: Create Link Table for my sales versus my budget
Best I have to help further is the following Design Blog post, hopefully it may clarify something for you to where you can get it sorted. My post will also kick things back up, so someone else my holler as well...