Thank you so much for this answer.
How do I hide the null values? should I be creating separate calculated field for each dimension to hide the null values? Im having a text chart with more than 20 columns, each has many nulls values, want to show black " " instead of null, please help.
sorry to bother you again, but my scenario has changed, I want to display only the matched and unmatched from S1,S3 both ds referencing S2.
should I use two separate joins or a single one joining them in single go? and how do I use calculated field to bring all the required fields in display.