Shay Shmeltzer's Oracle Development Tools Tips

  • October 2, 2009

Changing the Aggregation of an ADF Pivot Table

Shay Shmeltzer
Director of Product Management - Oracle

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):


Join the discussion

Comments ( 2 )
  • guest Tuesday, September 17, 2013

    Can we change the aggregate type dynamically based on the column coming in. We have columns that change from one customer to another.

    For an instance



    <item value="Name" label="Name"/>

    <data aggregateDuplicates="true" defaultAggregateType="SUM">

    <item value="Value" label="__NO_LABEL"/>



    In above SUM can be substituted as AVG for column and these aggregate types can come metadata, where Column1 - SUM, Column2 - AVG and so on.


  • guest Monday, September 15, 2014

    how I can Change the Aggregation of an ADF Pivot Table programmatically with SelectOneChoice ?

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.