0 Replies Latest reply on Apr 14, 2011 6:26 PM by peter19090231

    Groupingcollection-grouping-summaryrow-child grouping

    peter19090231

      I am struggling with a grouping collection problem, summaryrow respectively

       

      I have a three level grouping means 3 grouping fields each with summary row

       

      the bottom summaryrow has AVG as operation, the next one SUM. I want the second summaryrow to summarize the value of the grouping nodes below which is AVG of the nodes. how to achieve this???

       

      thank you in advance!

       

      highlighted is the first grouping level which has operation AVG, the summaryrow above should have the SUM of all subnodes grouping which have AVG.

       

      ScreenShot215.jpg

       

       

      structure:

       

      <mx:GroupingField name="Programm">
            <mx:summaries>
             <mx:SummaryRow summaryPlacement="group" >
              <mx:fields>
               <mx:SummaryField dataField="value" operation="SUM" />
              </mx:fields>
             </mx:SummaryRow>
            </mx:summaries>
           </mx:GroupingField>
           <mx:GroupingField name="Kategorie">
            <mx:summaries>
             <mx:SummaryRow summaryPlacement="group" >
              <mx:fields>
               <mx:SummaryField  dataField="value" operation="SUM"   /><!--summaryFunction="calculateSum"-->
              </mx:fields>
             </mx:SummaryRow>
            
            </mx:summaries>
           </mx:GroupingField>
           <mx:GroupingField name="Thema" >
            <mx:summaries>
             <mx:SummaryRow summaryPlacement="group" >
              <mx:fields>
               <mx:SummaryField dataField="value" operation="AVG" />
              </mx:fields>
             </mx:SummaryRow>
            </mx:summaries>
           </mx:GroupingField>