HTML OLAP Grid for ASP.NET

HTML OLAP Grid is an ASP.NET control with rich OLAP functionality for analysis of data using pivot tables. The user interface of the control is implemented using HTML, JavaScript and AJAX technologies.

OLAP Grid features

Colors cell's foreground depending on hierarchy’s members. Colors cell's background depending on measure values.

Embeds buttons that trigger the context menu for the cells. Embeds images within cells

Painting within cells Marks all the cells which values are below

Select a skin: Base Smoothness Redmond UI lightness UI darkness Start Black tie Blitzer Cupertino Dark hive Dot luv Eggplant Excite bike Flik Hot sneaks Humanity Le frog Mint choc Overcast Pepper grinder South steet Swanky purse Trontastic Vader

Show all panels Show pivot and data areas Show only data panel Clear the current layout Export JPEG CSV HTML PDF XLS XLSX Measures position Before allAfter all Rows areaColumns area Item Filter description ... Quantity Sales Categories-Products Date Cube structure Measures Quantity Sales Customers Address City Country Customers Phone PostalCode Region Employees Address City Country Employee Name HomePhone PostalCode Region Products Categories Categories-Products Products Suppliers Suppliers-Products Time Date Month (full name) Quarter Year Shippers Filter area Columns area Date   Rows area Values Categories-Pro...   Quantity Sales   Year 1996 1997 1998 Total Measures Quantity Sales Quantity Sales Quantity Sales Quantity Sales Categories Dairy Products 2,086 $40,980.45 4,374 $115,387.64 2,689 $78,139.19 9,149 $234,507.28 Grains/Cereals 549 $9,507.92 2,636 $56,871.82 1,377 $29,364.84 4,562 $95,744.59 Produce 549 $13,885.78 1,583 $54,940.77 858 $31,158.03 2,990 $99,984.58 Seafood 1,286 $19,391.22 3,679 $66,959.22 2,716 $44,911.29 7,681 $131,261.74 Condiments 962 $17,900.38 2,895 $55,368.59 1,441 $32,778.11 5,298 $106,047.08 Confections 1,357 $29,685.55 4,137 $82,657.75 2,412 $55,013.92 7,906 $167,357.22 Beverages 1,842 $47,919.00 3,996 $103,924.30 3,694 $116,024.87 9,532 $267,868.18 Meat/Poultry 950 $28,813.66 2,189 $80,975.11 1,060 $53,233.59 4,199 $163,022.36 Total 9,581 $208,083.97 25,489 $617,085.20 16,247 $440,623.87 51,317 $1,265,793.04 Loading... Loading...