You use this parameter to dynamically insert rows and columns of data at the end of expansions.
You can use the following features with this parameter:
You define one or more AfterRange parameters when you want to include additional data in rows or columns after the expansions.
If you have nested expansions, the system repeats all AfterRange ranges.
AfterRange parameters work the same as BeforeRange parameters. The only difference is their placement on the worksheet. For more information, see BeforeRange Parameter.
To use the AfterRange parameter, take the following steps:
From Interface for Excel, open the EvDRE report or input schedule you are building. Find a place in the worksheet to enter the range. This could be in a non-visible portion of the sheet.
In the AfterRange row of the Expand range parameter field, enter the cell range that describes the format you want to display.
Select
to insert a new column containing the sum of the values after the expansion columns.