I have a boolean metric with three dimensions: Position, Version and Month.
 

Position	Version	Q1	Q2	Q3	Q4
001	Forecast
001	Plan
002	Forecast

Positions can be a part of different teams over time. I have another metric, *Position Mapping* which is of type Team with the same dimensions as the boolean.

Now I want to add the Team dimension into the first metric. I have tried doing it like this:
‘My boolean’ by: → ‘Position Mapping’]

Team	Position	Version	Q1	Q2	Q3	Q4
Team A	001	Forecast
Team A	001	Plan
Team B	001	Plan
Team X	002	Forecast
Team Y	002	Forecast

This achieves the goal except for one thing. When I only hide empty columns it still shows all the combinations of Position, Version and Team as empty rows. The original metric didn’t.

How do I map the Team dimension into the metric so that it only shows where applicable. The reason for asking is that I have a table with seven different metrics and I want to show them in the table (using page filters) even when the metric is empty.