This example showcases the interactive features of the Analysis Grid element. Use the the controls at the top
to dynamically change the way the data is presented. Click the links within the data to "drill-down" to a detail report.

Analysis Grid - Northwind Orders

Formula  Layout  Sort  Filter  Group  Aggregate  Chart  Crosstab  Paging

Formula Column   A Formula Column is a new column you can create based on the results of a formula. More Formula Function Help Close Name Insert a column   Customer Ordered On Required By Freight Quantity Unit Price Shipped On Country Post Code   Insert Formula Data Type Number Text Date DateTime Display Format ###,###,##0.00 $###,###,##0.00 yyyy/MM/dd yyyy/MM/dd hh:mm:ss MM/dd/yyyy MM/dd/yyyy hh:mm:ss Bar Gauges Cell Colors Add Formula Columns:

Table Layout   Reorder and hide columns. Close Column Order Visible  Order ID . Customer .. Ordered On ... Required By .... Freight ..... Quantity ...... Unit Price ....... Shipped On ........ Country ......... Post Code OK

Sort Order   A Sort Order Columns sets the initial sort order of the rows. Close Data Column Customer Ordered On Required By Freight Quantity Unit Price Shipped On Country Post Code     Order Direction Ascending Descending     Add Sort Order Columns:

Row Filter   Filtering removes rows that you don't want to show. Close Filter Column Customer Ordered On Required By Freight Quantity Unit Price Shipped On Country Post Code Comparison = < <= >= > <> Starts With Contains Date Range Value ... Calendar X  to  ... Calendar X  to ... Select a Value X Add Filters:

Row Grouping   Organize the list by grouping and sub-grouping on data values. Close Grouping Column Customer Ordered On Required By Shipped On Country Post Code     by Year Quarter Month Day Add Groups:

Aggregate   Aggregates are totals, averages, standard deviations, maximums, and minimums that appear at the top of the report. Aggregates values also appear at each Grouping level. Close Data Column Ordered On Required By Freight Quantity Unit Price Shipped On Country Post Code     Aggregate Function Sum Average Standard Deviation Count Distinct Count Minimum Maximum     Add Aggregates:

Charts   Add a Pie, Bar, Line, Curved Line, or Scatter chart. Close Add: PieBarLineCurved LineScatter Plot Label Column X-Axis Column Customer Ordered On Required By Freight Quantity Unit Price Shipped On Country Post Code    by Year Quarter Month Day Ordered On Required By Freight Quantity Unit Price Shipped On Freight Quantity Unit Price     Data Column Y-Axis Column Freight Quantity Unit Price Data Aggregation Sum Average Standard Deviation Count Distinct Count Minimum Maximum Add Charts:

Crosstabs   A Crosstab is also called Pivot Table. Each column of the Crosstab table is represented by the unique values in the Header Values column. Each row of the Crosstab table is represented by the distinct values in the Label Values column. The "cells" are derived from the Aggregate Values column by adding, counting, or averaging (depending on the Aggregate Function) all the values unique to each Crosstab and Label Column. Close Header Values Column Ordered On Required By Freight Quantity Unit Price Shipped On Country Post Code    by Year Quarter Month Day The crosstab will have one column for each unique value. Label Values Column Ordered On Required By Freight Quantity Unit Price Shipped On Country Post Code    by Year Quarter Month Day The crosstab will have one row for each unique value. Aggregate Values Column Ordered On Required By Freight Quantity Unit Price Shipped On Country Post Code The contents of the crosstab as the Sum, Average, Standard Deviation or Count of the Header and Label columns. Aggregate Function Sum Average Standard Deviation Count The function used to aggregate the values in the crosstab cells. Add Crosstabs:

Paging   Set the number of rows displayed per page, or remove the paging controls and show all rows. Close Show all rows  Show paging  Rows per Page OK

Table     1 2 3 4 5 6 7 8 9 10    Order ID Customer Ordered On Required By Freight Quantity Unit Price Shipped On Country Post Code 10248 VINET 07/04/96 08/01/96 $32.38 12 $32.38 07/16/96 France 51100 10248 VINET 07/04/96 08/01/96 $32.38 10 $32.38 07/16/96 France 51100 10248 VINET 07/04/96 08/01/96 $32.38 5 $32.38 07/16/96 France 51100 10249 TOMSP 07/05/96 08/16/96 $11.61 9 $11.61 07/10/96 Germany 44087 10249 TOMSP 07/05/96 08/16/96 $11.61 40 $11.61 07/10/96 Germany 44087 10250 HANAR 07/08/96 08/05/96 $65.83 10 $65.83 07/12/96 Brazil 05454-876 10250 HANAR 07/08/96 08/05/96 $65.83 35 $65.83 07/12/96 Brazil 05454-876 10250 HANAR 07/08/96 08/05/96 $65.83 15 $65.83 07/12/96 Brazil 05454-876 10251 VICTE 07/08/96 08/05/96 $41.34 6 $41.34 07/15/96 France 69004 10251 VICTE 07/08/96 08/05/96 $41.34 15 $41.34 07/15/96 France 69004 10251 VICTE 07/08/96 08/05/96 $41.34 20 $41.34 07/15/96 France 69004 10252 SUPRD 07/09/96 08/06/96 $51.30 40 $51.30 07/11/96 Belgium B-6000 10252 SUPRD 07/09/96 08/06/96 $51.30 25 $51.30 07/11/96 Belgium B-6000 10252 SUPRD 07/09/96 08/06/96 $51.30 40 $51.30 07/11/96 Belgium B-6000 10253 HANAR 07/10/96 07/24/96 $58.17 20 $58.17 07/16/96 Brazil 05454-876 10253 HANAR 07/10/96 07/24/96 $58.17 42 $58.17 07/16/96 Brazil 05454-876 10253 HANAR 07/10/96 07/24/96 $58.17 40 $58.17 07/16/96 Brazil 05454-876 10254 CHOPS 07/11/96 08/08/96 $22.98 15 $22.98 07/23/96 Switzerland 3012 10254 CHOPS 07/11/96 08/08/96 $22.98 21 $22.98 07/23/96 Switzerland 3012 10254 CHOPS 07/11/96 08/08/96 $22.98 21 $22.98 07/23/96 Switzerland 3012

Reset | Save | Restore | Refresh