Forum Discussion
Matrix - Display values across different months along the same row
Here is my dataset:
| ID | Group | Target | Target Date | Row Group |
| 1 | Group1 | Target1 | 01/01/2023 | 1 |
| 2 | Group1 | Target2 | 10/01/2023 | 2 |
| 3 | Group1 | Target3 | 01/02/2023 | 1 |
| 4 | Group2 | Target1 | 01/01/2023 | 1 |
| 5 | Group2 | Target2 | 01/02/2023 | 1 |
| 6 | Group2 | Target3 | 01/02/2023 | 2 |
Row Group = ranking of each Target in the same Group and Target Date (month) ordered by Target Date
I am trying to display this data in a matrix, in the following format (Rows are Group > Row Group, Value is First Target), however, when I apply a filter, I end up with empty cells in some of the rows.
I understand why this is happening, but wanted to ask if there was a way I could make the Row Group dynamic so that it re-evalutes when a filter is applied. In the example above, Group 2 > Target 3 would become part of Row Group 1. Or perhaps there is a better approach to achieving this?
1 Reply
Instead of Row Groups use CONCATENATEX
