Design issue

[QFanatic]

hi guys

Please find attached. 

this is so simple, I cant believe I'm battling with it...In the attached model i have Customer Names and Sales for certain Channels. Note - I always ONLY want to see where Date_Selector = Last 3 days.

e.g. Woody has a Volume of 3 for the 12th. Peter has nothing for the last 3 days BUT I want to see that he has nothing...

How do I do it? it would have been simple if I could just ignore the last requirement - to see where all 3 days are Zero as well,...you will see in my code I have been able to "catch" the Null Volume, but how would I be able to "get" the "Full_Name as its on the "wrong" side of the join...

This is an urgent requirement please.

Thank you!

[lironbaram · Accepted solution]

hi 

if you want to display all values if a dimension 

just check the box as in the picture below