Michael Shparber on 03 Jun 2022 07:22:56
As of today, if I use several measures in a matrix and also use a field as a column, the matrix will show all the measures for all the values of the field.
We would like much more flexibility.
To allow nesting of columns and measures, but to specify what measure should be "splitted" by columns, and what measures shouldn't.
This will allow much more flexibility in matrix.
For example:
https://1drv.ms/u/s!AoP_9ampPIT7gbwH1sNuSJ2-xI53hA?e=DUrdXl
Here you can see that only Sales measure is "split" by "Year-Month" column, while all other measures are not.
- Comments (1)
RE: Allow unbalanced nested combinations of measures and columns in Matrix
And I know I can do workarounds, like build a separate measure for each of the last 3 months, etc...But I don't want workarounds, I want to see this feature as built in.Also, dynamic column/measures names....