BeforeRange Parameter 
You use this parameter to dynamically insert rows and columns at the beginning of expansions.
Features
If you have nested expansions, the system repeats all BeforeRange ranges.
The BeforeRange parameter is like a template that you design by identifying the range somewhere in the sheet (possibly in a non-visible portion), and that the expansion process places into the body of the report.
The system places the ranges specified in the row expansions horizontally starting from the first column of the row headings range. The system places column ranges vertically starting from the first row of the column headings range.
The system copies the format and formulas for the entire range. The value is only copied for the portion relating to the headings.
If you also expand the columns, the portion of the row range that falls inside the data range needs only to be defined for one column. The column expansion duplicates that portion for all expanded columns. If there is a before range on a column, and also an expansion of rows, the portion of the column ranges that falls inside the data range only needs to be defined for one row.
Activities
To define a BeforeRange parameter:
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 can be in a non-visible portion of the sheet.
In the BeforeRange row of the Expand range parameter fields, enter the cell range that describes the format you want to display.