Multi-dimensional Data Analysis (MDDA) refers to the process of summarizing data across multiple levels (called dimensions) and then presenting the results in a multi-dimensional grid format. This process is also referred to as OLAP, Data Pivot., Decision Cube, and Crosstab.  

ReportBuilder’s Crosstab component can be used to perform MDDA. Three types of dimensions can be defined: Column, Row and Value. Column and Row dimensions are used to define summarization levels and Value dimensions are used to specify calculations.

The process of MDDA is best explained via an example. Suppose that our dataset contains the following sales information: 

SalesMonth
State
AmountPaid

The Crosstab component can be used to produce a grid showing the total, average and number of sales summarized by state for each month. The output of the report is shown below.