New to Telerik UI for ASP.NET MVC? Download free 30-day trial

Local binding

Loading Demo...

EXAMPLE
VIEW SOURCE
Edit in Theme Builder
Change Theme
Default
SASS

LESS
- Default
- Bootstrap
- Material
- Launch Theme Builder
- Black
- Blue Opal
- Bootstrap v3
- Default
- Fiori
- Flat
- High Contrast
- Material
- Material Black
- Metro
- Metro Black
- Moonlight
- Nova
- Office 365
- Silver
- Uniform

            
                        local_flat_data_binding.cshtml
                    
                        Local_Flat_Data_BindingController.cs
                    
                        ProductService.cs

Also available for:

API REFERENCE

kendo.syncReady(function(){jQuery("#configurator").kendoPivotConfigurator({"height":570,"filterable":true,"sortable":true});}); kendo.syncReady(function(){jQuery("#pivotgrid").kendoPivotGrid({"configurator":"#configurator","columnWidth":120,"height":570,"filterable":true,"sortable":true,"dataSource":{"type":(function(){if(kendo.data.transports['aspnetmvc-ajax']){return 'aspnetmvc-ajax';} else{throw new Error('The kendo.aspnetmvc.min.js script is not included.');}})(),"transport":{"prefix":""},"error":onError,"rows":[{"name":"Discontinued","expand":true}],"columns":[{"name":"CategoryName","expand":true},{"name":"ProductName"}],"measures":{"values":[{"name":"Sum"}]},"schema":{"data":"Data","total":"Total","errors":"Errors","cube":{"measures":{"Average":{"field":"UnitPrice","aggregate":"average","format":"{0:c}"},"Sum":{"field":"UnitPrice","aggregate":"sum","format":"{0:c}"}},"dimensions":{"ProductName":{"caption":"All Products"},"CategoryName":{"caption":"All Categories"},"Discontinued":{"caption":"Discontinued"}}},"model":{"fields":{"ProductID":{"type":"number"},"ProductName":{"type":"string"},"UnitPrice":{"type":"number"},"UnitsInStock":{"type":"number"},"Discontinued":{"type":"boolean"},"LastSupply":{"type":"date"},"UnitsOnOrder":{"type":"number"},"Category":{"type":"object"},"CategoryID":{"type":"number","defaultValue":null},"QuantityPerUnit":{"type":"string"},"CategoryName":{"type":"string","from":"Category.CategoryName"}}}},"data":{"Data":[{"ProductID":1,"ProductName":"Chai","UnitPrice":18.00,"UnitsInStock":39,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"10 boxes x 20 bags"},{"ProductID":2,"ProductName":"Chang","UnitPrice":19.00,"UnitsInStock":17,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":40,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"24 - 12 oz bottles"},{"ProductID":3,"ProductName":"Aniseed Syrup","UnitPrice":10.00,"UnitsInStock":13,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":70,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"12 - 550 ml bottles"},{"ProductID":4,"ProductName":"Chef Anton\u0027s Cajun Seasoning","UnitPrice":22.00,"UnitsInStock":53,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"48 - 6 oz jars"},{"ProductID":5,"ProductName":"Chef Anton\u0027s Gumbo Mix","UnitPrice":21.35,"UnitsInStock":0,"Discontinued":true,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"36 boxes"},{"ProductID":6,"ProductName":"Grandma\u0027s Boysenberry Spread","UnitPrice":25.00,"UnitsInStock":120,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"12 - 8 oz jars"},{"ProductID":7,"ProductName":"Uncle Bob\u0027s Organic Dried Pears","UnitPrice":30.00,"UnitsInStock":15,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":7,"CategoryName":"Produce"},"CategoryID":7,"QuantityPerUnit":"12 - 1 lb pkgs."},{"ProductID":8,"ProductName":"Northwoods Cranberry Sauce","UnitPrice":40.00,"UnitsInStock":6,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"12 - 12 oz jars"},{"ProductID":9,"ProductName":"Mishi Kobe Niku","UnitPrice":97.00,"UnitsInStock":29,"Discontinued":true,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":6,"CategoryName":"Meat/Poultry"},"CategoryID":6,"QuantityPerUnit":"18 - 500 g pkgs."},{"ProductID":10,"ProductName":"Ikura","UnitPrice":31.00,"UnitsInStock":31,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"12 - 200 ml jars"},{"ProductID":11,"ProductName":"Queso Cabrales","UnitPrice":21.00,"UnitsInStock":22,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":30,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"1 kg pkg."},{"ProductID":12,"ProductName":"Queso Manchego La Pastora","UnitPrice":38.00,"UnitsInStock":86,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"10 - 500 g pkgs."},{"ProductID":13,"ProductName":"Konbu","UnitPrice":6.00,"UnitsInStock":24,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"2 kg box"},{"ProductID":14,"ProductName":"Tofu","UnitPrice":23.25,"UnitsInStock":35,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":7,"CategoryName":"Produce"},"CategoryID":7,"QuantityPerUnit":"40 - 100 g pkgs."},{"ProductID":15,"ProductName":"Genen Shouyu","UnitPrice":15.50,"UnitsInStock":39,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"24 - 250 ml bottles"},{"ProductID":16,"ProductName":"Pavlova","UnitPrice":17.45,"UnitsInStock":29,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"32 - 500 g boxes"},{"ProductID":17,"ProductName":"Alice Mutton","UnitPrice":39.00,"UnitsInStock":0,"Discontinued":true,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":6,"CategoryName":"Meat/Poultry"},"CategoryID":6,"QuantityPerUnit":"20 - 1 kg tins"},{"ProductID":18,"ProductName":"Carnarvon Tigers","UnitPrice":62.50,"UnitsInStock":42,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"16 kg pkg."},{"ProductID":19,"ProductName":"Teatime Chocolate Biscuits","UnitPrice":9.20,"UnitsInStock":25,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"10 boxes x 12 pieces"},{"ProductID":20,"ProductName":"Sir Rodney\u0027s Marmalade","UnitPrice":81.00,"UnitsInStock":40,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"30 gift boxes"},{"ProductID":21,"ProductName":"Sir Rodney\u0027s Scones","UnitPrice":10.00,"UnitsInStock":3,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":40,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"24 pkgs. x 4 pieces"},{"ProductID":22,"ProductName":"Gustaf\u0027s Knäckebröd","UnitPrice":21.00,"UnitsInStock":104,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":5,"CategoryName":"Grains/Cereals"},"CategoryID":5,"QuantityPerUnit":"24 - 500 g pkgs."},{"ProductID":23,"ProductName":"Tunnbröd","UnitPrice":9.00,"UnitsInStock":61,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":5,"CategoryName":"Grains/Cereals"},"CategoryID":5,"QuantityPerUnit":"12 - 250 g pkgs."},{"ProductID":24,"ProductName":"Guaraná Fantástica","UnitPrice":4.50,"UnitsInStock":20,"Discontinued":true,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"12 - 355 ml cans"},{"ProductID":25,"ProductName":"NuNuCa Nuß-Nougat-Creme","UnitPrice":14.00,"UnitsInStock":76,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"20 - 450 g glasses"},{"ProductID":26,"ProductName":"Gumbär Gummibärchen","UnitPrice":31.23,"UnitsInStock":15,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"100 - 250 g bags"},{"ProductID":27,"ProductName":"Schoggi Schokolade","UnitPrice":43.90,"UnitsInStock":49,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"100 - 100 g pieces"},{"ProductID":28,"ProductName":"Rössle Sauerkraut","UnitPrice":45.60,"UnitsInStock":26,"Discontinued":true,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":7,"CategoryName":"Produce"},"CategoryID":7,"QuantityPerUnit":"25 - 825 g cans"},{"ProductID":29,"ProductName":"Thüringer Rostbratwurst","UnitPrice":123.79,"UnitsInStock":0,"Discontinued":true,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":6,"CategoryName":"Meat/Poultry"},"CategoryID":6,"QuantityPerUnit":"50 bags x 30 sausgs."},{"ProductID":30,"ProductName":"Nord-Ost Matjeshering","UnitPrice":25.89,"UnitsInStock":10,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"10 - 200 g glasses"},{"ProductID":31,"ProductName":"Gorgonzola Telino","UnitPrice":12.50,"UnitsInStock":0,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":70,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"12 - 100 g pkgs"},{"ProductID":32,"ProductName":"Mascarpone Fabioli","UnitPrice":32.00,"UnitsInStock":9,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":40,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"24 - 200 g pkgs."},{"ProductID":33,"ProductName":"Geitost","UnitPrice":2.50,"UnitsInStock":112,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"500 g"},{"ProductID":34,"ProductName":"Sasquatch Ale","UnitPrice":14.00,"UnitsInStock":111,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"24 - 12 oz bottles"},{"ProductID":35,"ProductName":"Steeleye Stout","UnitPrice":18.00,"UnitsInStock":20,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"24 - 12 oz bottles"},{"ProductID":36,"ProductName":"Inlagd Sill","UnitPrice":19.00,"UnitsInStock":112,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"24 - 250 g jars"},{"ProductID":37,"ProductName":"Gravad lax","UnitPrice":26.00,"UnitsInStock":11,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":50,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"12 - 500 g pkgs."},{"ProductID":38,"ProductName":"Côte de Blaye","UnitPrice":263.50,"UnitsInStock":17,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"12 - 75 cl bottles"},{"ProductID":39,"ProductName":"Chartreuse verte","UnitPrice":18.00,"UnitsInStock":69,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"750 cc per bottle"},{"ProductID":40,"ProductName":"Boston Crab Meat","UnitPrice":18.40,"UnitsInStock":123,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"24 - 4 oz tins"},{"ProductID":41,"ProductName":"Jack\u0027s New England Clam Chowder","UnitPrice":9.65,"UnitsInStock":85,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"12 - 12 oz cans"},{"ProductID":42,"ProductName":"Singaporean Hokkien Fried Mee","UnitPrice":14.00,"UnitsInStock":26,"Discontinued":true,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":5,"CategoryName":"Grains/Cereals"},"CategoryID":5,"QuantityPerUnit":"32 - 1 kg pkgs."},{"ProductID":43,"ProductName":"Ipoh Coffee","UnitPrice":46.00,"UnitsInStock":17,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":10,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"16 - 500 g tins"},{"ProductID":44,"ProductName":"Gula Malacca","UnitPrice":19.45,"UnitsInStock":27,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"20 - 2 kg bags"},{"ProductID":45,"ProductName":"Rogede sild","UnitPrice":9.50,"UnitsInStock":5,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":70,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"1k pkg."},{"ProductID":46,"ProductName":"Spegesild","UnitPrice":12.00,"UnitsInStock":95,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"4 - 450 g glasses"},{"ProductID":47,"ProductName":"Zaanse koeken","UnitPrice":9.50,"UnitsInStock":36,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"10 - 4 oz boxes"},{"ProductID":48,"ProductName":"Chocolade","UnitPrice":12.75,"UnitsInStock":15,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":70,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"10 pkgs."},{"ProductID":49,"ProductName":"Maxilaku","UnitPrice":20.00,"UnitsInStock":10,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":60,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"24 - 50 g pkgs."},{"ProductID":50,"ProductName":"Valkoinen suklaa","UnitPrice":16.25,"UnitsInStock":65,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"12 - 100 g bars"},{"ProductID":51,"ProductName":"Manjimup Dried Apples","UnitPrice":53.00,"UnitsInStock":20,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":7,"CategoryName":"Produce"},"CategoryID":7,"QuantityPerUnit":"50 - 300 g pkgs."},{"ProductID":52,"ProductName":"Filo Mix","UnitPrice":7.00,"UnitsInStock":38,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":5,"CategoryName":"Grains/Cereals"},"CategoryID":5,"QuantityPerUnit":"16 - 2 kg boxes"},{"ProductID":53,"ProductName":"Perth Pasties","UnitPrice":32.80,"UnitsInStock":0,"Discontinued":true,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":6,"CategoryName":"Meat/Poultry"},"CategoryID":6,"QuantityPerUnit":"48 pieces"},{"ProductID":54,"ProductName":"Tourtière","UnitPrice":7.45,"UnitsInStock":21,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":6,"CategoryName":"Meat/Poultry"},"CategoryID":6,"QuantityPerUnit":"16 pies"},{"ProductID":55,"ProductName":"Pâté chinois","UnitPrice":24.00,"UnitsInStock":115,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":6,"CategoryName":"Meat/Poultry"},"CategoryID":6,"QuantityPerUnit":"24 boxes x 2 pies"},{"ProductID":56,"ProductName":"Gnocchi di nonna Alice","UnitPrice":38.00,"UnitsInStock":21,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":10,"Category":{"CategoryID":5,"CategoryName":"Grains/Cereals"},"CategoryID":5,"QuantityPerUnit":"24 - 250 g pkgs."},{"ProductID":57,"ProductName":"Ravioli Angelo","UnitPrice":19.50,"UnitsInStock":36,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":5,"CategoryName":"Grains/Cereals"},"CategoryID":5,"QuantityPerUnit":"24 - 250 g pkgs."},{"ProductID":58,"ProductName":"Escargots de Bourgogne","UnitPrice":13.25,"UnitsInStock":62,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"24 pieces"},{"ProductID":59,"ProductName":"Raclette Courdavault","UnitPrice":55.00,"UnitsInStock":79,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"5 kg pkg."},{"ProductID":60,"ProductName":"Camembert Pierrot","UnitPrice":34.00,"UnitsInStock":19,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"15 - 300 g rounds"},{"ProductID":61,"ProductName":"Sirop d\u0027érable","UnitPrice":28.50,"UnitsInStock":113,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"24 - 500 ml bottles"},{"ProductID":62,"ProductName":"Tarte au sucre","UnitPrice":49.30,"UnitsInStock":17,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"48 pies"},{"ProductID":63,"ProductName":"Vegie-spread","UnitPrice":43.90,"UnitsInStock":24,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"15 - 625 g jars"},{"ProductID":64,"ProductName":"Wimmers gute Semmelknödel","UnitPrice":33.25,"UnitsInStock":22,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":80,"Category":{"CategoryID":5,"CategoryName":"Grains/Cereals"},"CategoryID":5,"QuantityPerUnit":"20 bags x 4 pieces"},{"ProductID":65,"ProductName":"Louisiana Fiery Hot Pepper Sauce","UnitPrice":21.05,"UnitsInStock":76,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"32 - 8 oz bottles"},{"ProductID":66,"ProductName":"Louisiana Hot Spiced Okra","UnitPrice":17.00,"UnitsInStock":4,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":100,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"24 - 8 oz jars"},{"ProductID":67,"ProductName":"Laughing Lumberjack Lager","UnitPrice":14.00,"UnitsInStock":52,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"24 - 12 oz bottles"},{"ProductID":68,"ProductName":"Scottish Longbreads","UnitPrice":12.50,"UnitsInStock":6,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":10,"Category":{"CategoryID":3,"CategoryName":"Confections"},"CategoryID":3,"QuantityPerUnit":"10 boxes x 8 pieces"},{"ProductID":69,"ProductName":"Gudbrandsdalsost","UnitPrice":36.00,"UnitsInStock":26,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"10 kg pkg."},{"ProductID":70,"ProductName":"Outback Lager","UnitPrice":15.00,"UnitsInStock":15,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":10,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"24 - 355 ml bottles"},{"ProductID":71,"ProductName":"Flotemysost","UnitPrice":21.50,"UnitsInStock":26,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"10 - 500 g pkgs."},{"ProductID":72,"ProductName":"Mozzarella di Giovanni","UnitPrice":34.80,"UnitsInStock":14,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":4,"CategoryName":"Dairy Products"},"CategoryID":4,"QuantityPerUnit":"24 - 200 g pkgs."},{"ProductID":73,"ProductName":"Röd Kaviar","UnitPrice":15.00,"UnitsInStock":101,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":8,"CategoryName":"Seafood"},"CategoryID":8,"QuantityPerUnit":"24 - 150 g jars"},{"ProductID":74,"ProductName":"Longlife Tofu","UnitPrice":10.00,"UnitsInStock":4,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":20,"Category":{"CategoryID":7,"CategoryName":"Produce"},"CategoryID":7,"QuantityPerUnit":"5 kg pkg."},{"ProductID":75,"ProductName":"Rhönbräu Klosterbier","UnitPrice":7.75,"UnitsInStock":125,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"24 - 0.5 l bottles"},{"ProductID":76,"ProductName":"Lakkalikööri","UnitPrice":18.00,"UnitsInStock":57,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":1,"CategoryName":"Beverages"},"CategoryID":1,"QuantityPerUnit":"500 ml"},{"ProductID":77,"ProductName":"Original Frankfurter grüne Soße","UnitPrice":13.00,"UnitsInStock":32,"Discontinued":false,"LastSupply":"\/Date(1614297600000)\/","UnitsOnOrder":0,"Category":{"CategoryID":2,"CategoryName":"Condiments"},"CategoryID":2,"QuantityPerUnit":"12 boxes"}],"Total":77}},"dataCellTemplate":null,"kpiStatusTemplate":null,"kpiTrendTemplate":null,"columnHeaderTemplate":null,"rowHeaderTemplate":null});}); #configurator { width: 400px; min-width: 400px; display: inline-block; vertical-align: top; } #pivotgrid { width: 67%; display: inline-block; vertical-align: top; } .hidden-on-narrow { display: inline-block; vertical-align: top; }

Description

This demo for the Telerik ASP.NET MVC PivotGrid component shows how you can populate the component with local flat data. The demo features filtering and sorting of rows and columns. To sort the PivotGrid rows and columns, click on the fields in the headers, the field menu or use the PivotGrid Configurator.

To enable the sortable functionality, use the Sortable() method.

Support & Learning Resources

Was this demo helpful?

YES NO

Tell us how we can improve this demo

Submit Skip