Custom Calculations in Decomposition Tree

For the decomposition tree, data gets aggregated in the extension. Thats why pre-aggregated fields like AGG(Profi Ratio) are not allowed to be used in the extension.

Decomposition Tree: Warning when using aggregated measures

To decompose calculations like a Profit Ratio, they have to be calculated in the extension. You can do this in the Custom Calculations section. All parts of the calculation have to be present in the Measure Values shelf.

Custom Calculations in Decomposition Tree