Report Studio

Nested Calculations in Crosstabs

If a crosstab contains nested calculations, the calculations are performed in the following order by default:

outermost calculation on the columns
innermost calculation on the columns
outermost calculation on the rows
innermost calculation on the rows

If there are solve order ties, column items are calculated before row items, and outer nesting items before inner nesting items.

Related Topics:

Creating a Calculation—How to create calculations in Report Studio.
Multiple Calculations in Crosstabs and Charts—Working with multiple calculations in crosstabs and charts
Resolve Multiple Calculations for Crosstabs and Charts—Resolving multiple calculations in reports.