I’m wondering how to use alignments in formulas in the data cube, calculated element transformation…
As illustration this is what I want to end up with:
But when adding a calculated element like this: return SUM($SomeMeasure$,$SomeHierarchy$)
I instead end up with:
I need to keep the ID in the result (and I have a bunch of other fields in the data cube also, so I haven’t been able to get the result I need with the aggregate transform.)
This works excellent when calculated in the metric set, but I want to re-use this calculation across many metric sets, hence why I want the calculation in the data cube.
What I’m I missing here?