Showing "non existing" values

Hi there, I have a list of Brands which have invested in specific marketing strategies.
I in the table below (screenshot) I want to show how much A, B, C and D have invested in each strategy BUT I also want to show where they have NOT invested.
Some brands show a Purchase 0 but this is only because a campaign was created but never delivered.
So for example Brand A should show:
Awareness 46K
Engagement 15K
Purchase 0
Consideration 0

Is there a way to do that in here?


That’s a data preparation task. you need to create a cross join dataset between your all Advertisers and Possible Strategies. Then have that act as Master dataset and do a Left outer join with your fact table based on both Advertiser and Strategy. That should give you what you are looking for. Hope this helps!


mmh thanks for the quick answer. Do you think that it could be possible to show this insight by using Narratives? any idea how to implement that instead?