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

Filtering

Show Filter Editor
Clear Filter
Page 1 of 8 (73 items)Prev12345678Next
Product Name[Filter]
Product Amount
Year(Ascending)[Filter]
Quarter(Ascending)[Filtered]
Customer(Ascending)[Filter]
[Collapse]2019[Collapse]2020Grand Total
Qtr 2Qtr 2
Alfreds Futterkiste
Antonio Moreno Taquería
Around the Horn
Berglunds snabbköp
Blauer See Delikatessen
Blondesddsl père et fils
Bon app'
Bottom-Dollar Markets
B's Beverages
Cactus Comidas para llevar
Grand Total
 $933.50$933.50
$5,716.91 $5,716.91
$2,352.90$304.00$2,656.90
$5,718.26 $5,718.26
$615.80$828.00$1,443.80
$2,281.41 $2,281.41
$1,845.00$1,167.75$3,012.75
$851.20$1,973.25$2,824.45
$1,074.30$1,620.00$2,694.30
$225.50$305.00$530.50
$162,502.20$143,296.93$305,799.13
Page 1 of 8 (73 items)Prev12345678Next
Show filter builder dialog[Quarter] Equals 'Qtr 2' Clear
Did this demo address your needs?
If you’d like us to extend this demo further, please describe your needs below.
Thank you in advance for your cooperation.
SEND FEEDBACK

The Filter Editor allows end-users to build complex filter criteria with an unlimited number of filter conditions, combined by logical operators. End-users can open the Filter by right-clicking on any header or header area and selecting the Show Filter menu item. Or, end-user can open it by clicking an image (*) or filter expression link displayed within the Filter panel.

Adding/Removing Conditions
To create and customize filter criteria, use the (+) and (x) buttons.

Changing a Field in a Filter Condition
To change a field, invoke the field list and choose the required field.

Changing an Operator in a Filter Condition
To change an operator, invoke the operator list and choose the required operator.

Editing a Value in a Filter Condition
To edit a value, click the operand value and type some text. To discard changes and close the active edit box, press ESC.


See Also:
Collapse/Expand
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
Multi-Use Site Controls