Configuring Summary Calculations

Click “Enable Summary Calculations” to invoke Filtered Summary’s aggregation capabilities. Using the Aggregate Column Index Property as the key, Filtered Summary will aggregate and filter the data using one of 4 calculation types and then insert into the destination range.

More on Aggregate Column Index

Aggregate column index is the column number for which you will roll up and aggregate the data. For example, in the image below, the aggregate column index is = 1. This will tell the component to  find all distinct values in the first column and then aggregate across the other columns appropriately.

filtered summary