Hi,
I was able to create the customSubtractionOperation.as file. Now I have an
issue displaying the summary row.
Sample code:
<grids:dataProvider>
<mx:GroupingCollection2 id="gc" source="{acSample}" >
<mx:Grouping label="DIFF" >
<mx:GroupingField name="FieldA" />
<mx:GroupingField name="FieldB" />
<mx:GroupingField name="FiledC">
<mx:summaries>
<mx:SummaryRow summaryPlacement="group">
<mx:fields>
<mx:SummaryField2 dataField="FY_01"
summaryOperation="customSubtractionOperation" />
<mx:SummaryField2 dataField="FY_02"
summaryOperation="customSubtractionOperation" />
<mx:SummaryField2 dataField="FY_03"
summaryOperation="customSubtractionOperation" />
</mx:fields>
</mx:SummaryRow>
</mx:summaries>
</mx:GroupingField>
</mx:Grouping>
</mx:GroupingCollection2>
</grids:dataProvider>
<grids:groupedColumns>
<columns:ExtendedAdvancedDataGridColumn headerText="FieldA"
dataField="FieldA" textAlign="left" width="150" />
<columns:ExtendedAdvancedDataGridColumn headerText="FieldB"
dataField="FieldB" textAlign="left" width="150" />
<columns:ExtendedAdvancedDataGridColumn headerText="FieldC"
dataField="FieldC" textAlign="left" width="150" />
<columns:ExtendedAdvancedDataGridColumn headerText="{acYears[0]}"
dataField="FY_01" textAlign="left" width="100" />
<columns:ExtendedAdvancedDataGridColumn headerText="{acYears[1]}"
dataField="FY_02" textAlign="left" width="100" />
<columns:ExtendedAdvancedDataGridColumn headerText="{acYears[2]}"
dataField="FY_03" textAlign="left" width="100" />
</grids:groupedColumns>
The issue is the it shows extra rows for each grouping field as:
COLUMN A | COLUMN B | COLUMN C | FY 01 | FY 02 | FY03
--------------------------------------------------------------------------
Field A value
Field B Value
Field C value | -XX
| -XX | -XX
Field A value 1 | Field B Value| Field C Value | XX | XX
| XX
Field A value 2 | Field B Value| Field C Value | XX | XX
| XX
How can I make the display similar as:
GROUP COLUMN | COLUMN A | COLUMN B | COLUMN C | FY 01 | FY 02
| FY03
--------------------------------------------------------------------------
Difference
| -XX | -XX | -XX
Field A value 1 | Field B Value| Field C Value |
XX | XX | XX
Field A value 2 | Field B Value| Field C Value |
XX | XX | XX
Difference
| -XX | -XX | -XX
Field A value 1 | Field B Value| Field C Value |
XX | XX | XX
Field A value 2 | Field B Value| Field C Value |
XX | XX | XX
Thanks,
--
View this message in context:
http://apache-flex-users.2333346.n4.nabble.com/Show-two-rows-diferences-in-Adv-Datagrid-tp10837p10918.html
Sent from the Apache Flex Users mailing list archive at Nabble.com.
