KB16397: How to enable each page-by field element combination to be exported to a separate worksheet in MicroStrategy Web when exporting to Microsoft Excel

In Strategy Web, a user can enable each page-by field element combination to be exported to a separate worksheet when exporting to Microsoft Excel. To do so, the user must perform the following steps:
 

• In Strategy Web, create a simple report with one attribute (e.g. the 'Subcategory' attribute) on the template of the report, one attribute (e.g. the 'Category' attribute) in the page-by section of the report, and one metric (e.g. the 'Revenue' metric) on the template of the report, as shown below:
  

• The user can then go to the 'File' menu and select 'Export', as shown below:
  

• In the 'Export Options' window, the user must select to export to 'Excel with formatting', then check the check box to 'Expand all page-by fields', and finally check the checkbox to 'Place each page on a separate sheet', as shown below:
  

• After selecting the appropriate settings in the previous step, the user can click on the 'Export' button and notice how each of the page-by field elements are exported to a separate worksheet within Microsoft Excel, as shown below: