property Aggregate.Caption as String
Specifies the caption of the Aggregate to be displayed on the column.

TypeDescription
String A String expression that defines the HTML Caption to be displayed on the Column, if the Aggregate function is applied to the column.
The Caption property indicates the HTML caption to be displayed on the column's header when the current Aggregate object is applied to the column. In other words, the Caption property is displayed in the column's header when the column is drag and drop to the control's pivot bar. The FormatPivotHeader property defines the format of the caption to be displayed on the column's header. The caggregate keyword in the FormatPivotHeader property defines the Aggregate's Caption property. The Name property of the Aggregate object defines the name to be displayed on the control's context menu. You can use the <img> HTML tag to display icons or pictures. Use the Images or HTMLPicture method to add icons or pictures to control.

The following screen shot shows the new Caption (<b>SUM</b>):

The following screen shot shows the default Caption (Sum):

The Caption property supports the following HTML tags: