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?
Thanks!!!