Branched from Adding Non-Existent Values to a Dimension
Thanks for your response!
As suggested, I did some research and performed "data scaffolding" to my data set, which worked perfectly. The issue I'm running into now is that I'm unable to blend two or more fields - based on values from a reference list - and achieve the same result. Here's my dilemma - if I assign the master data set as the primary data source and the two reference lists as secondary data sources, Tableau excludes values from the both reference lists that aren't present in the master data set. On the other hand, if I make one reference list a primary data source and the other a secondary, the values populate as desired for the primary but yields an '*' for the other.
I've done some research and understand this is the result of a "one-to-many" relationship. Essentially, I'm trying to create a chart with the one reference list populating row values, the other reference list populating column values, and the master data set populating the aggregate sum count. Is this even possible?
As you can see, I branched this to a new thread because this is a different question.
It would really help us help you if you can post a sample packaged workbook. If you have confidential data, please mock up something using the Superstore database, or see Anonymize your Tableau Package Data for Sharing |Tableau Support Community, and Attaching a Packaged Workbook.