Exporting data from a crosstab

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

You can export data from a crosstab to a CSV and PDF file. All of the dimensions, measures, and topN filters applied on the crosstab are applicable to exported output. 

To export from a crosstab, perform the following steps: 

1. From the Toolbox, click Workbooks, and then select a workbook and a worksheet. 

2. Confirm that you are looking at the crosstab you want to export and that you have applied any filters you want to use.

3. In the Design view, click Options at the top of the page, then choose Export.

4. On the Export dialog box, select the File Format from PDF or CSV.
   
   

   Open

   

   By default, the CSV format is selected.

5. From the Export View, select any of the following options.

   1. Tabular: Select this option to export data as a table.

   2. Cross-Tabular: Select this option to export data as WSWYIG Cross tabular export keeping column headers as columns in CSV. When exporting with this option, you will see a proper Excel export of the crosstab rather than its tabular version.
      NOTE: If you have grand total and subtotals in your crosstab, they will not be exported in the CSV output.

6. If needed, Select the Columns that you want to export. This lets you select various levels in dimension hierarchies, and you can also select columns that may not be displayed in your worksheet. For example, if you are looking at State level information in a worksheet, you may want to export Region or City information too. In such cases, the levels above those selected are disabled. By default, the attribute hierarchy columns are exported.

7. If needed, modify the Line Separator, Field Separator, and Enclosed by options. 

8. Specify whether to Include headers in the report and whether the resulting file should be a Zipped folder.

9. You can also specify whether to maintain Measure Formatting. When this option is selected, all the measures will be exported in the formats defined for them (if any) in the dataset or semantic model properties.

10. Click Apply. 

Export considerations

• Grand total and subtotals will not be exported in CSV output.

• Member expansion is converted to level expansion during export.

• Exported CSV or PDF may not be visually similar to the UI when measure sorting with dimensions on the column is applied, as member expansion is converted to level expansion during export.

• Max Rows and Max Columns limits for export are separate from the limit applied on UI.

• Measure sorting with dimensions on a column will be ignored in the following cases during export:

  • Exporting to CSV or PDF in a tabular manner.

  • Sorting is applied on sub-totals or grand-total (for CSV export).