It would be great if dimensions could be added to metrics sheets in a similar way to dimensions on rows on pivot tables, with associated metric sub totals.
Could you share more about your use case?
For example we might to present metrics split by Region.
In these cases, a new metric sheet with a filter set to that Region would need to be added for each version of the dimension, as well as an unfiltered aggregate version.
We have the same - we would want to ‘pivot’/partition the metric sheet by a dimension - this limits our ability to use the metric sheets to its full capability.
For now, I think you can create Business Calculation Fields to overcome this shortcoming.
Btw, it’s only a workaround, there may be a lot of copy and paste when the dimension has too many value.
Absolutely, although this multiplies out for each metric that needs to be included, creating friction / overhead. Not an essential as there is a workaround, just nice to have for quality of life.