Calculated Member Example - Creating a Member and Including it in a Dynamic Report

In this example, a calculated member is created in the Account Finance Hierarchy and named Gross Sales.

Property fields are completed and a formula is added via Rule Builder. In this case, the new Gross Sales account will be equal to gross revenue for all products minus returns.

In Dynamic Reports, the new Gross Sales account is mapped at the page level.

Run the Dynamic Report and all data is displayed for Gross Sales.