How to Export to Excel All Members in a Rollup in a Dynamic Report

For example, if you have an account group called Income Statement and you want to see the individual accounts that roll up to Income Statement when you export the report to Excel, complete the following steps.

1. Open the Dynamic Report and select the Select All Childrenoption in Member Selector.

   

2. Run the report. The hierarchy will be expanded to show all individual accounts.

3. Export to Excel and all accounts will be shown as in the output when you ran the report.