Resolve Multiple Calculations for Crosstabs and Charts

If an intersection 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 Summary aggregation 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 Summary aggregation property set to Calculated, the normal rules for solve order apply.

Procedure

  1. Click the data item for which to specify the solve order.

    A data item can have only one solve order value. Consequently, if a data item is in a query that is used in more than one context and you want the data item to have a different solve order in each context, you must use a separate data item.

  2. Click the Show properties icon Show properties icon, and in the Properties pane, set the Solve order property to an integer value.