Click the ‘Add Matrix’ option under Add icon located at the bottom-left corner to add a matrix view of your data.
Use matrix to summarize your report data in the form of cross-section of fields in rows and columns. For example, ‘Product Type’ and ‘Product’ in columns; ‘Location’ and ‘State’ in rows. A cross section of ‘Product Type’, ‘Product’ and ‘Location’, ‘State’ will display sales of that product in that location.
Figure 36: Creating a Matrix
To place a field as matrix row, drag it from Available Fields list and drop it in Row Fields (or, select a field and click button). To place a field as matrix column, drag it from Available Fields list and drop it in Column Fields (or, select a field and click button).
To place a field on summary (intersection of row and column), drag a field from Available Fields list and drop it in Summary Fields (or click button).
These fields will be calculated for summary/totals. Functions listed in Function dropdown box will depend on data type of the Summary Field.
You can drop multiple fields in Row Fields, Column Fields and Summary Fields box. Fields appear higher in sequence in Row Fields and Column Fields will appear on outer side of matrix. Summary Fields are placed left to right on the matrix. To move a field up or down, click or button.
Show When opens filtering criteria to apply on column and row fields. The column/row that meets the condition shows up on the matrix when you run the report.
You can highlight a Cell, Cell Family, or an Entire Row or Column of a matrix based on a condition. The matrix highlights the summary field using the specified Style.
In case of a hyperlinked field (specified at the query object level), you can drill down to open another report or URL on clicking the value of field on matrix.
Grouping values of Numeric fields
You can specify an integer value to group numeric fields. For example, to have groups of 0-9, 10-19 … specify 10 in Group By box of respective row in Row Fields or Column Fields box.
Grouping values of Date type fields
You can group a date by Minute, Hour, Day, Week (Sunday to Saturday), Month, Quarter (Jan-Mar, Apr – Jun, Jul – Sep, Oct – Dec), Year. Select an option from Group By box of respective row in Row Fields or Column Fields box.
Clicking Clear Matrix button would clear the specified matrix properties to start all over again.
Designers/Users can link Matrix and Chart so that any changes made in one component gets reflected automatically in the other. Linking can be done in both ways- Matrix to Chart and vice versa.
Figure 37: Link Matrix and Chart
You can also edit the matrix name on the title bar by double-clicking on it.
You can delete a matrix control by clicking Delete Matrix icon on the top-right position of the matrix.
Click Delete option on the down arrow next to Matrix tab on the bottom-left to delete the entire matrix view. A confirmation message pops up confirming the deletion.