MicroStrategy ONE

PivotTable Settings

Starting in MicroStrategy ONE (June 2024), you can customize your Import PivotTable experience with PivotTable settings.

To enhance your import experience, you can turn on attribute and metrics smart mapping into dedicated Pivot Table fields.

  1. Click More Items in the Excel add-in side panel and click Settings.

  2. Expand the Object Information section and the Pivot Table section.

  3. Toggle on Attributes to automatically import attributes into the Rows section of a Pivot Table.

  4. Toggle on Metrics to automatically import metrics into the Values section of a Pivot Table.

  5. Your import options will save until you manually update them.