Forum Discussion
Solved
add measure in a multiple dimensions Matrix
Good afternoon, I need to add a column with the sum of the last quarter of the last year and this year sales, I have both, year and quarter as column dimension and when I add the measure that adds the sales, the measure column repeats itself in the matrix:
E.g. Before measure:
| 2023 | 2024 | |||||
| Toy | 1 | 2 | 3 | 1 | 2 | 3 |
Toy 1 | 23 | 21 | 56 | 35 | 12 | 64 |
| Toy 2 | 53 | 51 | 61 | 94 | 38 | 62 |
E.g. After measure:
| 2023 | 2024 | |||||||||||
| Toy | 1 | Measure | 2 | measure | 3 | measure | 1 | measure | 2 | measure | 3 | measure |
Toy 1 | 23 | ## | 21 | ## | 56 | ## | 35 | ## | 12 | ## | 64 | ## |
| Toy 2 | 53 | ## | 51 | ## | 61 | ## | 94 | ## | 38 | ## | 62 | ## |
But my matrix goal is like this:
| 2023 | 2024 | ||||||
| Toy | 1 | 2 | 3 | 1 | 2 | 3 | Measure |
Toy 1 | 23 | 21 | 56 | 35 | 12 | 64 | sum |
| Toy 2 | 53 | 51 | 61 | 94 | 38 | 62 | sum |
How can I achieve this?
