An interesting option that is very useful when we build such a type of analysis is the ability to have either subtotals by categories at various levels, or grand totals by rows and/or columns, or both. This recipe shows you how to build subtotals by rows or columns and how to enable the visualization of grand totals. Note that this recipe makes use of Pentaho Analyzer, a tool available only in the EE version of Pentaho.
The following steps detail how easily we can add subtotals to rows' categories:
From the Browse Files perspective, go to the
/public/Pentaho BA Cookbook/Analysis Reports
location, select the Analysis Report 1 report saved in the previous recipe, and choose Open from the File Actions menu on the right.From the Customer dimension, drag-and-drop the Country level to the Rows Fields layout zone and position it before the Product Department level (as a parent of that level). The analyzer recalculates the report.
In the report's...