Date Leveling

Date leveling is a hierarchy representation of dates and associated measures, which enables you to view the data over different periods of time.

To use this hierarchy, create a report that shows the total Actual Gross Revenue amount for each year. Drill down from year to show gross revenue per quarter, sales per month, gross revenue per week and gross revenue per day, and then drill back up to gross revenue per year. The date hierarchy aggregates the measures by the required hierarchy or leveling period.

To configure date leveling when defining a custom subject area, use the Configure Date Leveling step of the train stop to either allow or disallow leveling. You may need to expand the field list in the Date field to select or clear the Date Leveling check box, as applicable.

For more information on where the Configure Date Leveling step appears in the train stop, see Creating Custom Subject Areas.