Aggregate functions are very useful in SSRS reports in AX R3 to calculate the aggregate values that show the numeric data. Totals are an obvious need in all reports. For example, the sum aggregate function calculates the total of transaction amounts. SSRS provides easy and powerful aggregation capabilities. This recipe will discuss a couple of aggregation methods and how they can be applied at different levels.
In this recipe two aggregations will be implemented:
To define the total value of transactions implement the following steps: