Thanks Emiliano for the suggestion.
I'm actually trying not to hide the data. I'm trying to create the records that are missing with a value = to $0. Due to the formulas I'm working with I need a value for the missing records for the formula to work.
We have already been able to correct this within our SQL (main data source), but for only 1 store and only for 1 month.
The same has to be done, but for every store, sub-category, for each month over 2a 4 month period...lots and lots of records. I was hoping there is a way to do this via a second data source or through a formula within Tableau to mock this data.
Hi Don no problem!
By default the "Missing Values" are hidden in Tableau. So the article I had posted shows you how to "unhide" these missing values (particularly relevant with dates). Also it is worth to consider that it might be better to update the datasource directly as adding a formula or another datasource means that the function or join to the other datasource needs to run each time as opposed to a single update on the database.
Turns out that a simple cross join in SQL fixed the problem.