Analyse interactive reports
With interactive reports that contain cross tabs, you can modify the report using a tool called Interactive Cross tabs.
About cross tabs
A cross tab displays summary, or aggregate values, such as sums, counts, or averages, in a row‑and‑column matrix similar to a spreadsheet. For example, you can use a cross tab to view sales data for each product line, by year, or total sales for each product line, by geography, and so on.
The aggregate values in a cross tab are arranged in dimensions and measures, and each cross tab can display multiple dimensions and multiple measures. Dimensions are categories, such as employees or cost centres, by which measures are aggregated. Measures represent values that are counted or aggregated, such as hours. Each detail cell in a cross tab displays an aggregate value.
A cross tab consists of the following three areas:
- Row area
- Column area
- Detail area
The row and column areas contain the dimension values. The detail area contains one or more measures displaying aggregate data.
With the Interactive Cross tabs tool, you can add, remove, reorganise, and customise the data in a cross tab to examine relationships. You can drill down into dimension levels to display detail data, drill up to display summary data, filter, group, and sort data in a crosstab, perform calculations, create aggregate data, and display crosstab data in a grid or in a chart.
When you select Analyse in the interactive report, the Interactive Cross tabs tool opens. The measures and dimensions are listed in the left side of the workspace. The action bar across the top enables you to manipulate the data.
Edit
|
Undo, Redo |
|
Refresh Data
|
|
Delete
|
| |
Options
- Measure Header Orientation — Set horizontal or vertical orientation
- Empty Rows and Columns — Select empty rows and enter text to display in the empty cells.
- Page Break — Enable page breaks. Enter a number in the Row Interval or Column Interval boxes.
- Totals Display — Indicate where to display totals.
- Drill Size — Enter the number of data rows for which aggregate values are calculated in the cross tab.
- Width — Enter the default cell width.
|
View
| |
Pivot
|
| |
Drill Up/Drill Down
|
Insert
|
New Computed Measure — To display computed data in the cross tab, you can create a column that displays calculated data based on an expression that Interactive Cross tabs evaluates. For a complete list of supported functions and their descriptions, see Functions used in computed column expressions. |
Format
|
Font — Select one of the listed fonts |
|
Alignment — Align left, right, or centre |
|
Theme — Select one of the listed themes |
|
Format Data
|
| |
Conditional Formatting
|
