The GroupFooterType functionality in DynamiCube 3 has been changed and improved from DynamiCube 2.5.

When a GroupFooterType(x) = DCFCalculated you can supply your own formula using GroupFooterExpression(x). If you do not specify a GroupFooterType for an intersection, DynamiCube will use the default setting depending on the AggregateFunc of the associated DataField.

Defaults that are assumed when GroupFooterType(x) is not supplied for a DimensionField / DataField combination:

Defaults

* This will give us the average of all aggregated data

When a field is added to the DataFields collection, you should not be required to set the GroupFooterType for each field. DynamiCube will set the GroupFooterTypes according to the AggregateFunc of each associated DataField.

This is important due to the fact that there could be many DataFields and a single RowField. Supplying a GroupFooterType for each DataField would be tedious and unnecessary. If the user does not like the default value that is supplied for them, they can change it with the following code:

  
' show the [true average of sales] for all states using the
' DCFCalculated GroupFooterTypes enumeration
' When this (indexed) property is set, you must use the
'GroupFooterExpression property to define your summary calculation formula

Dim stateField As DynamiCubeLibCtl.Field
Set stateField = DCube1.Fields.Add("State", "State", DCRow)
stateField.GroupFooterCaption = "Avg Sales / Max Profit"
stateField.GroupFooterType("avgSales") = DCFCalculated
stateField.GroupFooterExpression("avgSales") = "groupsum(sumSales)/groupsum(cntSales)"