The Grouping Aggregate RDL report is designed with the Grouping and Total concept to organize
and summarize the data using Tablix data region.
It breaks the information down into quarterly intervals, so that you can analyze the information according
to the order year.
- Row grouping is used to group the data based on quarterly sale.
- Using the
Total
feature, the total sales amount for each quarter and year is calculated in
Tablix data region.
- The sales value for each quarter is formatted in the
Currency
format to improve the readability of report.
More information about the Tablix data region can be found in this documentation section.