Field Customization

 
Region
Country
Product Amount
Order Year
Order Quater
Customer
Product Name
2015
2015 Total
2016
2016 TotalGrand Total
Q1Q2Q3Q4Q1Q2
Alfreds Futterkiste
Aniseed Syrup
$60$60$60
Chartreuse verte
$378$378$378
Escargots de Bourgogne
$520$520$520
Flotemysost
$440$440$440
Grandma's Boysenberry Spread
$400$400$400
Lakkalikööri
$270$270$270
Original Frankfurter grüne Soße
$26$26$26
Raclette Courdavault
$825$825$825
Rössle Sauerkraut
$690$690$92$92$782
Spegesild
$24$24$24
Vegie-spread
$880$880$880
Alfreds Futterkiste Total
$1,092$1,210$2,302$1,343$960$2,303$4,605
Ana Trujillo Emparedados y helados
Camembert Pierrot
$340$340$340
Konbu
$60$60$60
Mascarpone Fabioli
$320$320$320
Mozzarella di Giovanni
$350$350$350
Queso Cabrales
$42$42$42
Singaporean Hokkien Fried Mee
$70$70$70
Teatime Chocolate Biscuits
$63$63$63
Tofu
$69$69$69

The DevExpress Blazor Pivot Table allows users to customize data layout by dragging field headers between different areas: Rows, Columns, Data, Filter. Users can configure/personalize Pivot Table structure without modifying the underlying data source or code.

The component also includes a Field List designed to manage Pivot Table structure. Users can:

  • Reorder fields within each area.
  • Move fields across different areas.
  • Display/hide fields.
  • Change field sort order.
  • Set field filters.
  • Defer layout update.

To display the Field List, use the ShowFieldList method. In this demo, a DxButton is used to invoke the Field List.