Skip to main content

worksheet : PIVOT_FORMAT_VALFIELD

Purpose​

Format a Pivot VALUE Field in a PivotTable, uses standard Excel number formatting (e.g., "$#,##0.00", "#,###,##0")

How to Use​

CommandSrcModelSrcObjectTgtModelTgtObject
worksheet : PIVOT_FORMAT_VALFIELDDefault: targetPivotTable
Arg Options:
- pivotTableName
- REG:regVar
fieldName
- REG:regVar
—stringValue
- REG:regVar