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.
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 Create a Simple Spreadsheet Application for details on how to provide a Ribbon UI for the SpreadsheetControl).
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.