Satish from the Flex team has been working on expanding the logic available in our OLAPDataGrid to help provide an example of a Pivot Component, similar to what you'd see in Excel. It's in alpha quality, but is a great example of the power of the Flex Data Visualization Components.
Check it out and provide feedback!

i will have a new pivot