Resolve Multiple Calculations for Crosstabs and Charts |
If an intersection point in a crosstab or chart contains a value that is derived from multiple calculations, you can specify the order in which to perform the calculations. The solve order must be a positive numeric value. The calculations are performed from lowest to highest solve order value.
Setting the Rollup Aggregation Function property to Calculated for a data item assigns a solve order that is higher than any other data item in a query, unless a solve order is explicitly specified. If there are multiple data items that have the Rollup Aggregation Function property set to Calculated, the normal rules for solve order precedence apply.
Related Topics: