Hi, I'm a Flex beginner. Could someone please help me how to
display crosstab query result in DataGrid? The following query
returns 6 columns:
- First column: values in the field Sell_Channel
- Second: Sum(Revenue Total) from the Revenue field.
- Others: Revenue Subtotal by Sell_Channel and quarter.
Quarters are values stored in the field name Quarter. In Datagrid,
what would be the datafield for these 4 quarter columns?
Here is my SQL:
TRANSFORM Sum(Revenue.RevenueTotal) AS SumOfRevenueTotal
SELECT Revenue.Sell_Channel, Sum(Revenue.RevenueTotal) AS
[Total Of RevenueTotal]
FROM Quarter INNER JOIN Revenue ON Quarter.FiscalQuarter =
GROUP BY Revenue.Sell_Channel