Crosstab Properties: Advanced Tab
The Advanced tab in the 'Crosstab Properties' dialog box provides the following crosstab-specific properties.
Fill Blank Cell With Zero |
Places a zero value in measure cells corresponding to row and column heading combinations for which no records exist. Otherwise, these cells are simply left blank. |
Summary Cells Side By Side |
Places multiple aggregated measures side-by-side, rather than stacking them vertically. |
Enable Drilling |
Allows the user to drill up and down in date or dimension fields. See Drilling Down into a Crosstab for more information. |
Enable Ad Hoc |
Allow end users to access the Crosstab Editor and edit the table. |
Shrink to Fit |
When enabled, this reduces the height of the table to match the number of records displayed. For example, if the original table height (as designed) was 10 rows, and the user then makes selections which restrict the result set to five rows, the bottom table border retracts or “shrinks” to eliminate any empty rows at the bottom of the table. |
Data Tip View |
A Viewsheet component is displayed when mouse hovers over crosstab area. The component is filtered based on the hover region. See Data Tip View for more details. |
Flyover Views |
Allows you to select a set of Viewsheet components which will be adaptively filtered as the user hovers the mouse or clicks on the crosstab area. (Select 'On Click Only' if you want the filtered components to update when the user clicks.) Filtering is based on the grouping fields (dimensions) in the row and column on which the user hovers or clicks. See Flyover Views for more details. |

| << Crosstab Properties: General Tab | © 1996-2013 InetSoft Technology Corporation (v11.4) | Crosstab Properties: Hierarchy Tab >> |