Chapter 4. Advanced Aggregations

In this chapter, we will cover the following recipes:

• Using TOTAL to calculate the percentage of total and the percentage of subtotal

• Using AGGR to calculate the percentage of the maximum value

• Using AGGR to resolve a "Sum of Rows" issue

• Creating a dynamic AGGR expression for a Group dimension using Dollar Expansion

• Using RangeMax to return only positive numbers

• Creating a dynamic Part-to-Whole pie chart

• Creating a colored treemap using colormix

• Using RangeSum to calculate a rolling total in a multi-dimension table

• Showing only the top 3 values in a pivot table

• Creating a Statistical Control Chart using Standard Deviation

• Creating a Moving Range chart

• Creating a Control Chart using Moving Range