Skip to main content
BuyLog In
WPF Controls
Search in…
Docs > WPF Controls > Controls and Libraries > Spreadsheet > Visual Elements > Dialogs > PivotTable Solve Order Dialog
All docs
V23.2
WPF Controls
Prerequisites
What's Installed
.NET/.NET Core Support
Common Concepts
MVVM Support
MVVM Framework
Controls and Libraries
Reporting
Data Grid
Ribbon, Bars and Menu
Charts Suite
Pivot Grid
Scheduler
Spreadsheet
Spreadsheet Control API
Get Started
Spreadsheet Document
Supported Formats
Cell Basics
Formulas
Defined Names
Data Binding
Data Validation
Data Presentation
Tables
Pivot Table Overview
Charts and Graphics
Form Controls
Printing
Events
Protection
Operation Restrictions
Find and Replace
Mail Merge
Visual Elements
Dialogs
Format Cells Dialog
Paste Special Dialog
Edit Hyperlink Dialog
Symbol Dialog
Create Table Dialog
Change Chart Type Dialog
Find and Replace Dialog
Encrypt Document Dialog
Password Dialog
Protect Workbook Dialog
Protect Sheet Dialog
User Permissions Dialog
Insert Function Dialog
Function Arguments Dialog
Name Manager
New Name Dialog
Create Names from Selection Dialog
Subtotal Dialog
Data Validation Dialog
Properties Dialog
Page Setup Dialog
Print Preview Dialog
Header and Footer Dialog
Create PivotTable Dialog
Move PivotTable Dialog
Change PivotTable Data Source Dialog
PivotTable Field List
PivotTable Value Field Settings Dialog
PivotTable Field Settings Dialog
PivotTable Sort Dialog
Insert Calculated Field Dialog
Insert Calculated Item Dialog
PivotTable Solve Order Dialog
PivotTable Options Dialog
New Formatting Rule Dialog
Conditional Formatting Rules Manager
Context Menus
Services
Themes and Templates
Shortcuts
Examples
Rich Text Editor
Tree List
Gauge Controls
Map Control
Layout Management
Windows Modern UI
Printing-Exporting
Data Editors
Navigation Controls
Spell Checker
Property Grid
PDF Viewer
TreeMap Control
Gantt Control
Diagram Control
Windows and Utility Controls
Dialogs, Notifications and Panels
Office File API
Sankey Diagram Control
Sunburst Control
Heatmap Control
Scheduler (legacy)
Localization
Security Considerations
Support, Debug, and Troubleshooting
Redistribution and Deployment
Desktop & Web App UI Framework (Powered by EF Core)
Get More Help
API Reference
Download CHM

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.

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

    DXSpreadsheet_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