Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
hi
if you want to display all values if a dimension
just check the box as in the picture below
hi
if you want to display all values if a dimension
just check the box as in the picture below