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