Overview of table
QMF Vision provides added reporting functionality by the way of tables, also known as a cross-tab visualization. A cross-tab helps you summarize complex data that is displayed on a data sheet and can be organized in multiple ways. Organizing data through a cross tab allows the data which is displayed vertically to be displayed horizontally.
About this task
- Swap the rows and columns by clicking SWAP.
- Toggle between the Simple-tab and cross-tab view by clicking CROSS-TAB.
- Hide or show a column by clicking the Show/Hide icon. This option is visible when you hover the mouse over a column header.
You can format data in cross-tab visualizations by selecting the following options available in TOOLBOX.
- View the breadcrumb trail of the navigational path when you drill down the data in a column by selecting Breadcrumb.
- View the sub total of every row by selecting Sub Total.
- View the grand total of every column by selecting Grand Total
- View the serial number of every row by selecting Line Number.
- View Grey stripes on alternate rows by selecting Striped Row.
- Modify the background colors for dimension, measures, and groups.
-
If the Y axis of cross-tab has two or more dimensions, you can drill down a column by selecting the column and clicking Drill.
-
Select a column and apply formatting options. You can modify the alignment of the text, font size, and font color.
- View cells, columns, rows, and table as percentage.
- Click a dimension to view the various tasks you can perform on a Context.
- The Sort option enables you to apply conditions on the context and see the resulting values in the cross-tab. You can sort the values by name or value.
- The Exception option enables you to select outliers and define custom exceptions.