Unfortunately I do not know how to do this since the actual data is coming from a Tableau data server. I could make the budget data fake, but I'm not sure how to make the actual data fake.
"Show missing values" isn't an option when I tried it.
are you doing the work within Tableau Desktop?
Yes, I am. Version 10.0
I've tried to create a visualization of what's happening. Here's two dummy tables with a combined table showing what's happening. Because my act is a SAP HANA View I can't do pure data blending like if using two excel data sources. You will see that Region 4 is excluded for Brand 2 in the combined table below because the record for it doesn't exist in Actual.
I am running into the exact same issue as you.
Have been struggling with it for a week now, trying joins, and blending, but nothing is working.
Last resort is just working with excel.
Did you ever end up resolving this?