Changing the Aggregation of an ADF Pivot Table

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

pivot002.jpg

Comments:

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

<pivotTableDataMap>

<columns>

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

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

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

</data>

</columns>

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.

sandhya

Posted by guest on September 17, 2013 at 08:22 AM PDT #

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

Posted by guest on September 15, 2014 at 12:50 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

me
I'm a Director of Product Management for the Oracle Mobile and Development Tools.
Follow me:
Search

Archives
« September 2015
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today