Create asymmetric calculations on stacked rows or columns in an exploration

You can now create calculations that apply to a single nested dimension set on rows or columns in a view. Because these calculations are applied to a single nested set for a given dimension and are not common to all nested sets for the dimension, they are called asymmetric calculations.

Asymmetric calculations can be confined within a single nested set or span multiple nested sets of the same dimension.

In this example, which is confined within a single nested set, you can see the Putters+Woods asymmetric calculation in the Products set. It calculates the total of Putters and Woods in Canada. Note that the calculation appears just once; it is not duplicated in both nested Products sets.

This example shows the Golf Accessories + Putters asymmetric calculation, which spans multiple nested sets of the Product dimension. It calculates the total of Golf Accessories in the United States plus Putters in Canada. Though the calculation spans the nested Products set for both United States and Canada, it appears only in the nested Products sets for Canada.

For full details, see Add an asymmetric calculation to a view.