Join Different Levels of Hierarchies Along Axis

By - Updated April 25, 2017

When there are multiple hierarchies in one axis, we can join different levels of them dynamically. For example, if you have product and account dimension in the row, we can show aggregated account value (A) for all non-leaf products, and show the full account hierarchy for leaf products.

To define this form, we need to customize its ROW definition in NATIVE MDX.

Copy and paste the code below into the ROW tab under NATIVE MDX.


Then you should get the target form.