the problem arises when i add the valuation amount from the secondary data source. Then it will not blend. So if i would to Aggregate the values from the two data sources with a calculated field, the value from the secondary data source disappears. Because that very same entity does not have any value in the primary data source. And the "show empty rows" selection is automatically greyed out when i blend data.
Use the cross join with fullouter in tableau and add dimension calc as
+ IFNULL([List ID1],' '))
Same as measure [Amount]
Drag both in view and get the output.
Cross join with two ds.twbx 31.5 KB
i am not able to open the workbook you attached. What version is it? I have the 10.4.1 Version. Would you be able to save it as an earlier version perhaps?
Thank you a lot