...
Ad Hoc Editor’s Standard Crosstab Layout |
By default, a crosstab displays a subset of the data its query retrieves. Click Full Data to view the full dataset. This can be helpful in showing a more accurate view of the final view (by showing more data). Click Sample Data or No Datato improve performance if you find the editor has slowed down.
Common tasks when working with Ad Hoc crosstabs include:
...
Set the granularity of date groups
...
When you select a date field as a group, you can specify the granularity of the group values. Right-click the group label, select Change Grouping and select Year, Quarter, Month, or Day.
...
Pivot a single group
...
To pivot any group from row to column or vice-versa, select the group by clicking its label, then drag it to the other area. You can also right-click the group label and select Move to Column Group for row groups or Move to Row Group for column groups.
...
Pivot entire crosstab
...
To pivot all row groups to column groups and vice-versa at the same time, click 
.
...
Filtering
...
Right-click a group label and select Create Filter to slicing (Keep Only).
...
Keep Only
...
Slice out a single group by right-clicking its group value and selecting Keep Only. Use Ctrl-click to select multiple members to keep.
...
Exclude
...
Remove a group value from any group by right-clicking it and selecting Exclude. Use Ctrl-click to select multiple members to exclude.
...
Summaries (Totals)
...
By default, the crosstab includes grand totals of all row groups, shown in a Totals row at the bottom, and of all column groups, shown in a Totals column to the right.
To toggle the row totals, right-click the left-most row group and select Delete Row Summary or Add Row Summary. To toggle the column totals, right-click the top-most column group and select Delete Column Summary or Add Column Summary.
You cannot hide the inner totals of an expanded row or column group.
...
Change Summary Functions
...
Right-click a measure label and click Change Summary Function to select a summary function. For example, you may want to display an average rather than a total.
...
Column group limits
...
In some cases, the editor prompts you to confirm that you want it to return large amounts of data. When the number of column groups exceeds a configurable limit, the editor displays an ellipsis (...); its ToolTip indicates the number of remaining groups. Click the ellipsis to display them. For more information on configuration.
...
Sorting
...
Crosstabs support multiple levels of sorting:
- Right-click Measures to sort measure groups by label.
- Right-click a row or group label to sort its values. When your selection contains inner groups, they are also sorted.
- Right-click an inmost column header to sort the column values. Sorting can only be set for one column at a time.
...
Filter the numeric data shown in a crosstab to show only the rows with the top or bottom N values, where N is a number that you specify. For example, you can filter a crosstab to display only the top 10 values in a column.
Right-click the header you want to use for filtering and select one of these options:
- Filter Top N Values
- Filter Bottom N Values
- Don't Filter Values
Enter the number of values you want to show in the crosstab and then select whether to apply the filter across all row groups. You can also choose to show an aggregate of the unranked values in the crosstab.
...
Drill to detail
...
Click a measure to drill to open an Ad Hoc table that displays a summarized column for each measure in your crosstab; the table is filtered by the group values for the measure you clicked. The original crosstab and the summarized table operate independently.
...
By default, the Ad Hoc editor merges cells containing the same data into a larger, single cell to make the crosstab data easier to read.
...