Changing the Aggregation of an ADF Pivot Table
By Shay Shmeltzer on Oct 02, 2009
A quick tip for people using the ADF Pivot Table component.
When you are using a pivot table with ADF binding by default the table aggregates the data using the SUM function for each intersection of axises.
However - you can actually change the aggregation to be something else like Avg, Count and more.
To do this you'll need to go into the binding tab of your page, choose the pivotTable binding you added and navigate to the data in the structure pane. Then in the property inspector you'll see other options for the aggregation like this (right click -> view image for the full size version):