How to use the PivotComponent

If you want to provide "pivot Table" functionalities to ur application .. Just download the swc
from this post of mine .

You can see through the installation and samples there in the source , But just to give u a picture of how easy it is to use , say You have gotta do is

<fc:PivotComponent dataProvider="{flatData}" width="100%" height="100%">
<fc:DimensionList dataProvider="{flatData}" height="100%" width="100%"
color= "0xFFFFFF" alternatingItemColors="[0x000000,0x000000]"/>
<fc:MeasuresList dataProvider="{['Sales', 'Production', 'Cost']}" height="100%"
width="100%" id="m1" color= "0xFFFFFF" />
<fc:OLAPChartExtension height="100%" width="100%" measuresList="{m1}">
<fc:olapChart>
type="Column" showDataTips="true"/>
</fc:olapChart>
</fc:OLAPChartExtension>
<fc:OLAPDataGridExtension width="100%" height="100%"/>
</fc:PivotComponent>

Isnt it easy ?? Hey I have skipped the Layouting for displaying simplicity [ Use HBoxes and VBoxes to layout ]

[I think I have to come up with a component to poste codes .. Any suggestions .. please do give]

Here is much awaited PivotComponent in Flex

Well here is a implementation of Excels pivotComponent . I have used the OLAPDataGrid and OLAP API's of flex 3.0 .

For better experience click here



You are seeing

• Dimensions List ==> left corner where "company " etc are shown

• Measures List ==> Below the dimension's list . You can choose "Sum" , "Avg" etc

• TabNavigator which shows "Chart View " and "grid View"

• You can drag any dimension and drop it on to the Grid's or Charts row/column/slicer axis [ Grid n Chart will Prompt its acceptance]

• You ca perform filtering by opening the popup button and unselecting what u dont need

• You can perform slicing similarly

Source can be found here