I attached an example to illustrate my problem. I have to tables, Teams and Goals. First one shows the teams with their groups and the second shows their goals in each phase. I have a Pivot table showing the team and the phase with sum of goals.
But if a team does not have a goal in s specific phase, it is not shown. I want to show all the teams in this pivot table whether they have any goals or not in that specific phase.
