I have a boolean metric with three dimensions: Position, Version and Month.
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.
|001||Forecast||Team A||Team A||Team A||Team A|
|001||Plan||Team A||Team B||Team B|
|002||Forecast||Team X||Team X||Team Y||Team Y|
Now I want to add the Team dimension into the first metric. I have tried doing it like this:
‘My boolean’ [by: → ‘Position Mapping’]
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.