DataFunction (Property)

Applies To:

Chart and Pivot Facts objects, TargetFact object

Description:

Returns aggregate values that summarize groupings of data when applied to Chart, Pivot, gauges and (Live) Chart facts. From the user interface, data functions are available from the short cut menu and Chart and Pivot menus only if fact values are selected.

Use data functions to show the kind of values represented in Chart and Pivot reports, such as total, average, and maximum product sale by Quarter. You can use these data functions for Pivot and Chart Facts:

Sum (default )
Average
Count
Maximum
Minimum
Percent Grand
Percent Column
Percent Row
Null Count
Non-Null Count

Action:

Read-only

Constants:

The DataFunction property uses the BqDataFunction constant group, which consists of these values:

bqDataFunctionAverage
bqDataFunctionCount
bqDataFunctionIncrease (Pivot Totals properties, not Facts)
bqDataFunctionMaximum
bqDataFunctionMinimum
bqDataFunctionNone
bqDataFunctionNonNullAverage
bqDataFunctionNonNullCount
bqDataFunctionNullCount
bqDataFunctionPercentOfColumn
bqDataFunctionPercentOfRow
bqDataFunctionPercentofGrand (For Totals, not Facts)
bqDataFunctionSum

Example:

This example shows how to set the Product Line TopLabels column in the Pivot section to the average data function:

ActiveDocument.Sections["SalesPivot"].TopLabels["Product Line"].Totals[2]. DataFunction=bqDataFunctionAverage