Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Show All Themes

Calculated Fields

Page 1 of 5 (45 items)Prev12345Next
Extended Price[Filter]
Page 1 of 5 (45 items)Prev12345Next

The ASPxPivotGrid control allows you to create calculated fields. They do not simply obtain their values from a field in the data source. Instead, you specify a binding expression. The expression can be a formula, an aggregate function, or a window function.

This demo shows two calculated fields that use ExpressionDataBinding objects: Sales Person and Order Amount. Use the Sales Person Format and Order Amount Rule combo boxes to change the expressions.

Two other data fields rely on the CustomCellDisplayText event: Percent of OrderTotal and Bonus Amount. The Percent of OrderTotal field displays the percentage of the current order's sum in the order's total sum. Bonus Amount field displays 15% if the order amount is greater than $50,000 and 10% otherwise.

See Also:
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxPivotGridDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxPivotGridDemos