ADF Pivot Table example

The Pivot table is good for analyzing the data & It is widely used for the analytical purpose. ADF DVT provides the Pivot table capability and it is more powerful compare to ADF table. Using ADF Pivot table, we can do group by columns, transfer Row into Column and Column into Row,  Aggregation function, filtering, editable table, sorting, export to excel and much more. Here, we are going to create a Pivot table with three examples.

I have used the following Sales-Table to create Pivot . The Sales-Table has the following data.

Download the sales table DDL : sales.sql

 

Tablename: Sales

122416_0501_ADFPivotTab1 How to create an ADF Pivot Table example

 

 

Example1: Find out the total product price purchased by location (Mumbai & Delhi )

 

1. Create an ADF Fusion Web Application

2. Create an EO & VO object of Sales 

3. Create a JSF page. Drop the Sales View from Data Control into the JSF page, Select ADF Pivot Table as shown below

122416_0501_ADFPivotTab2 How to create an ADF Pivot Table example

 

 

4. As shown in the following image, drag and drop attributes then Click Finish

  • Drop ‘Location’ field from Available Attributes => Page Edge
  • Drop ‘Sex’ & ‘Product’ from Available Attributes => Row Edge
  • Drop ‘Price’ from Available Attributes => Data Labels

 

122416_0501_ADFPivotTab3 How to create an ADF Pivot Table example

 

 

5. Once done, give summary to the Pivot 

 

122416_0501_ADFPivotTab4 How to create an ADF Pivot Table example

 

 

6. Run this page will yield the following result. The Total product price in each location by Male & Female. 

 

 

2 How to create an ADF Pivot Table example

 

 

Example2: Find out the total price made through Online and Retail?

 

Create a Pivot Table like below

 Right click the below Image and Select Open in New tab for clear view
 

1 How to create an ADF Pivot Table example

 

Result of the above ADF PIVOT TABLE

 

ADF_PIVOT.gif How to create an ADF Pivot Table example

 

 

Example 3: Count the number of products purchased by category (Audio & Video)?

 

Create the Pivot table like below

ADF_PIVOT_TABLE_DRILLING How to create an ADF Pivot Table example

 

 

Result of the above ADF Pivot Table

ADF_PIVOT_TABLE1-1 How to create an ADF Pivot Table example

 

We can restructure the PIVOT after it render to the page

 

3 How to create an ADF Pivot Table example

govindan How to create an ADF Pivot Table example
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply šŸ™‚
govindan How to create an ADF Pivot Table example
Connect me
By | 2017-01-19T21:30:53+00:00 December 24th, 2016|Categories: ADF|Tags: , , , |0 Comments
Like us on Facebook.
Connect!