pivotAggregate - APEXlang Reference

`pivotAggregate`

Parent: savedReport

Applies whenpivot = true

Direct Properties:

Property	Type	Required	Default Value	Details
`heading`	`string`	No		data type=`string`; maxLen=4000 Identifies the aggregate column label

Property Groups:

aggregate

Property	Type	Required	Default Value	Details
`function`	`enum`	Yes		data type=`string`; lov=`STATIC` Valid values: `sum` `average` `max` `min` `median` `count` `countDistinct` `ratioToReportSum` `ratioToReportCount`
`column`	`string`	Yes		data type=`string`; maxLen=128
`column`	`string`	No		data type=`string`; maxLen=128 Applies when`function in (count)function in (countDistinct)function in (ratioToReportCount)`
`displaySum`	`boolean`	Yes	`false`	data type=`boolean`

aggregate {
  function: sum
  column: value
  displaySum: false
}

appearance

Property	Type	Required	Default Value	Details
`formatMask`	`string`	No		data type=`string`; maxLen=255

appearance {
  formatMask: value
}

layout

Property	Type	Required	Default Value	Details
`sequence`	`number`	Yes		data type=`number`; maxLen=22

layout {
  sequence: 42
}

advanced

Property	Type	Required	Default Value	Details
`staticId`	`string`	Yes		data type=`string`; maxLen=255

advanced {
  staticId: value
}

APEXlang Example

pivotAggregate sample (
    heading: value
    aggregate {
        function: sum
        column: value
        displaySum: false
    }
    appearance {
        formatMask: value
    }
    layout {
        sequence: 42
    }
    advanced {
        staticId: value
    }
)