PivotTable Solve Order Dialog

The Solve Order dialog allows end-users to specify the formula used to determine the cell value affected by multiple calculated items.

XtraSpreadsheet_Dialogs_SolveOrder

End-users can invoke this dialog by:

  • Selecting a cell with a miscalculated value;
  • Clicking the Solve Order... item in the Fields, Items, & Sets drop-down menu. Add the Calculations ribbon group to enable this button (refer to the Getting Started for details on how to provide a Ribbon UI for the SpreadsheetControl).

    XtraSpreadsheet_Dialogs_SolveOrder_Ribbon

The Solve Order dialog lists formulas for all calculated items in the PivotTable report. Only the last formula in the list is used to calculate the target cell value. End-users can reorder formulas in the list using the Move Up and Move Down buttons. Clicking the Delete button removes the selected calculated item.

See Also