How to export complete Pivot Grid data with multiple columns

When exporting pivot grid data that includes multiple columns, it is essential to ensure that the complete data is exported. This guide will help you configure the necessary settings to achieve this.

Enabling Save Nodes Property

To export the complete data, including the drill-down details, you must enable the “Save Nodes” property in the ‘Basic Settings’ category. This property helps maintain the expanded and collapsed state of nodes, even after the dashboard is reloaded.

Steps to Enable Save Nodes State Property

1. Navigate to Basic Settings:

   • Go to the ‘Basic Settings’ category in your pivot grid properties section.

2. Enable Save Nodes:

   • Locate the “Save Nodes State” property and enable it.

Visual Guide

Pivot Grid Format

Export Sheet Format

By following these steps, you can ensure that your exported pivot grid data includes all the necessary drill-down details.

Additional References

• Adding multiple columns in pivot grid
• Exporting Data Guide

For further assistance, please refer to the official documentation or contact support.