Applies to: 
Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)
...
This section describes the following:
Changing crosstab view
| Anchor | ||||
|---|---|---|---|---|
|
To change to the crosstab view, perform the following steps.
From the Toolbox, select Workbooks, then select a workbook and worksheet.
If needed, select the Design workspace.
Select the Crosstab option from the View Type list.
To see the total number of rows and columns returned from a query, right-click and select the Show Info option. If a query has color and chart dimensions both, you will view the count for each individual dimension.
View Crosstab
...
properties
| Anchor | ||||
|---|---|---|---|---|
|
If the Design view has Properties enabled, you will see the properties pane alongside the crosstab. By default, it is on the right. You may need to select whether you view Worksheet or Crosstab properties. Otherwise, see Configuring the Kyvos workspace to learn how to display the properties pane.
...
Crosstab Property | Description |
|---|---|
Max Rows | The maximumnumber of rows to be displayed on the crosstab. |
Max Columns | The maximumnumber of columns to be displayed on the crosstab. |
Repeat Member Values | Selecting this checkbox repeats the member values on the crosstab. Otherwise, the member values are displayed once. |
Response Chunk Size | Data in crosstab is fetched and rendered in chunks for best visualization. This property lets you specify the number of rows fetched in each chunk for crosstab.
NOTE: The chunk size you specify is applied only to this sheet. To specify the chunk size at the application level, you must use the kyvos.crosstab.response.chunksize property in the olapengine.properties file. |
Row Drill Options Column Drill Options | Specifies whether the drilled-down view should display levelsor member expansions.
NOTE: When Row or Column Expansion is set to Classic, you can set the drill options to memberor level. When they are set to Hierarchical, these options are not available. |
Row Expansion Column Expansion | In the drop-down list, select either Classic or Hierarchical expansion for rows and columns.
|
Show Expand Collapse Button | Allows you to view plus and minus icons for expanding and collapsing rows and levels and persist expansion. |
Persist Expansion | Allows you to persist the expansions when you reopen a saved worksheet. This specifies whether detailed data is displayed in separate rows or columns from the parent data. |
Show Totals | Use this checkbox to add totals to the crosstab and specify whether the totals should be displayed at the top or bottom of the crosstab. The totals shown reflect any filters applied to the data. Select whether to show the Grand total only, or Grand total and subtotal,or both.Use the icons to select rows, columns, or both.
|
Show Alternate Row Highlight | Allows alternate row highlighting for crosstabs. You must select any one of the following to specify which dimensions you want to highlight:
|
Heatmap Properties | Click the link if the heatmap feature is enabled in your installation. See Heatmap properties to configure a heatmap. |
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
NoteYou can set actions for a crosstab using the Options menu or by right-clicking a data item in a crosstab. |
Formatting column width and alignment
| Anchor | ||||
|---|---|---|---|---|
|
You can specify the alignment for all dimensions and measures and column width for crosstabs and tables. Left, Right, and Center alignment options are supported.
...
Navigate to the worksheet/dashboard where you want to specify the width and alignment.
Switch to the Design mode.
Right-click a measure of dimension and select the Settings options from the displayed menu.
On the Settings dialog box, specify the Alignment and Width (in pixels), and then click Apply.
By default, the numbers are aligned to the right, and the text is aligned to the left.
View member information
| Anchor | ||||
|---|---|---|---|---|
|
To view the number of members present on UI, right-click on the crosstab and select the Show info option. You will then see the number of members in a row and the number of members in the column.
From Kyvos 2024.2 onwards, you can also view the parameter filters (if applied) in the 'Show Info' dialog box.
...
Showing subtotal for selected dimension in crosstab
| Anchor | ||||
|---|---|---|---|---|
|
Kyvos enables the display of subtotals for a selected dimension in a crosstab. This feature allows users to manage the visibility of subtotals within the crosstab, aiding business users in avoiding large tables cluttered with unneeded totals and concentrating on the essential figures.
You can hide subtotals of selective attributes present in view.
You can hide subtotals of specific hierarchy whose levels are currently displayed.
You can hide subtotals of specific dimensions for both classical and hierarchical cases.
You can hide subtotals of dimensions present on both row and column axis.
Selective subtotals for dimensions will be preserved upon sheet saving.
You can export PDF with hidden subtotal of selective dimension.
You can Email with PDF attachment with hidden subtotal of the selected dimension.
To show subtotal for selected dimension in crosstab, perform the following steps.
From the Toolbox, select Workbooks, then select a workbook and worksheet.
If needed, select the Design workspace.
Select the Crosstab view type from the View Type list.
In the Properties pane, click Show Totals.
Click the Of property.
The list is displayed with all dimensions. You can select or clear the dimension for which you want to view or hide the sub total.
...
Related topics
| Child pages (Children Display) |
|---|