Pull down to refresh...
Release to refresh...
Refreshing...
-
Data Grid
- Overview
-
Data Binding
-
Paging and Scrolling
-
Editing
-
Grouping
-
Filtering and Sorting
- Focused Row
-
Row Drag & Drop
-
Selection
-
Columns
- State Persistence
-
Appearance
-
Templates
-
Data Summaries
-
Master-Detail
-
Export to PDF
-
Export to Excel
-
Adaptability
- Keyboard Navigation
-
Pivot Grid
- Overview
-
Data Binding
-
Field Chooser
-
Features
-
Export to Excel
-
Tree List
- Overview
-
Data Binding
- Sorting
- Paging
-
Editing
- Node Drag & Drop
- Focused Row
-
Selection
-
Filtering
-
Column Customization
- State Persistence
- Adaptability
- Keyboard Navigation
-
Scheduler
- Overview
-
Data Binding
-
Views
-
Features
- Virtual Scrolling
-
Grouping
-
Customization
- Adaptability
-
Html Editor
-
Chat
-
Diagram
- Overview
-
Data Binding
-
Featured Shapes
-
Custom Shapes
-
Document Capabilities
-
User Interaction
- UI Customization
- Adaptability
-
Charts
- Overview
-
Data Binding
-
Area Charts
-
Bar Charts
- Bullet Charts
-
Doughnut Charts
-
Financial Charts
-
Line Charts
-
Pie Charts
-
Point Charts
-
Polar and Radar Charts
-
Range Charts
-
Sparkline Charts
-
Tree Map
-
Funnel and Pyramid Charts
- Sankey Chart
-
Combinations
-
More Features
-
Export
-
Selection
-
Tooltips
-
Zooming
-
-
Gantt
- Overview
-
Data
-
UI Customization
- Strip Lines
- Export to PDF
- Sorting
-
Filtering
-
Gauges
- Overview
-
Data Binding
-
Bar Gauge
-
Circular Gauge
-
Linear Gauge
-
Navigation
- Overview
- Accordion
-
Menu
- Multi View
-
Drawer
-
Tab Panel
-
Tabs
-
Toolbar
- Pagination
-
Tree View
- Right-to-Left Support
-
Layout
-
Tile View
- Splitter
-
Gallery
- Scroll View
- Resizable
-
-
Editors
- Overview
- Autocomplete
-
Calendar
- Check Box
- Color Box
- Date Box
-
Date Range Box
-
Drop Down Box
-
Number Box
-
Select Box
- Switch
-
Tag Box
- Text Area
- Text Box
- Validation
- Custom Text Editor Buttons
- Right-to-Left Support
- Editor Appearance Variants
-
Forms and Multi-Purpose
- Overview
- Button Group
- Field Set
-
Filter Builder
-
Form
- Radio Group
-
Range Selector
- Numeric Scale (Lightweight)
- Numeric Scale
- Date-Time Scale (Lightweight)
- Date-Time Scale
- Logarithmic Scale
- Discrete scale
- Custom Formatting
- Use Range Selection for Calculation
- Use Range Selection for Filtering
- Image on Background
- Chart on Background
- Customized Chart on Background
- Chart on Background with Series Template
- Range Slider
- Slider
-
Sortable
-
File Management
-
File Manager
- Overview
-
File System Types
-
Customization
-
File Uploader
-
-
Actions and Lists
-
Maps
- Overview
-
Map
-
Vector Map
-
Dialogs and Notifications
-
Localization
Related Demos:
Your search did not match any results.
Loading...
Pivot Grid - Overview
DevExtreme ASP.NET MVC PivotGrid is a jQuery-based client-side control that can operate multi-dimensional data analysis. Explore PivotGrid features such as multiple summary calculation modes, state persistence, and virtual scrolling. You can configure the control with Razor C# syntax.
Was this demo helpful?
Feel free to share demo-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
Thank you for the feedback!
If you have technical questions, please create a support ticket in the DevExpress Support Center.
Backend API
x
@using DevExtreme.MVC.Demos.Models
<div id="pivotgrid-demo">
@(Html.DevExtreme().Chart()
.ID("pivotgrid-chart")
.CommonSeriesSettings(s => s.Type(SeriesType.Bar))
.Tooltip(t => t.Enabled(true).CustomizeTooltip("customize_tooltip").Format(Format.Currency))
.Size(s => s.Height(200))
.AdaptiveLayout(l => l.Width(450))
)
@(Html.DevExtreme().PivotGrid<Sale>()
.ID("pivotgrid")
.AllowSortingBySummary(true)
.AllowFiltering(true)
.ShowBorders(true)
.ShowColumnGrandTotals(false)
.ShowRowGrandTotals(false)
.ShowRowTotals(false)
.ShowColumnTotals(false)
.FieldChooser(c => c.Enabled(true).Height(400))
.DataSource(d => d
.Store(s => s.WebApi().Controller("PivotGridData"))
.Fields(fields => {
fields.AddFor(m => m.Region)
.Width(120)
.Area(PivotGridArea.Row)
.SortBySummaryField("Total");
fields.AddFor(m => m.City)
.Width(150)
.Area(PivotGridArea.Row);
fields.AddFor(m => m.Date)
.Area(PivotGridArea.Column);
fields.Add()
.GroupName("Date")
.GroupInterval(PivotGridGroupInterval.Month)
.Visible(false);
fields.AddFor(m => m.Amount)
.SummaryType(SummaryType.Sum)
.Format(Format.Currency)
.Area(PivotGridArea.Data);
})
)
.OnInitialized("bind_chart")
)
</div>
<script>
function customize_tooltip(args) {
return {
html: args.seriesName + " | Total<div class='currency'>" + args.valueText + "</div>"
};
}
function bind_chart(e) {
e.component.bindChart($("#pivotgrid-chart"), {
dataFieldsDisplayMode: "splitPanes",
alternateDataFields: false
});
e.component.on("contentReady", contentReady);
}
function contentReady(e) {
e.component.off("contentReady", contentReady);
var dataSource = e.component.getDataSource()
dataSource.expandHeaderItem("row", ["North America"]);
dataSource.expandHeaderItem("column", [2013]);
}
</script>
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx
xxxxxxxxxx