Number Format

Allows us to specify the required number format that PivotGrid should use in its values by setting the format option. Following number formats that are supported:

• number
• decimal
• currency
• percentage
• date
• time
• scientific
• accounting
• fraction

RELATIONAL

HTML

<ej-pivotgrid [dataSource.values]="values">
</ej-pivotgrid>

TS

//..
export class PivotGridComponent {
    //..
    constructor() {
        //..
        this.values= [{ fieldName: "Amount", fieldCaption: "Amount", format: "currency" },
                    { fieldName: "Quantity", fieldCaption: "Quantity", format: "decimal" }
        ],
        this.filters= []
    }
}

OLAP

TS

//..
export class PivotGridComponent {
    //..
    constructor() {
        //..
        this.values= [{ measures: [{ fieldName: "[Measures].[Internet Sales Amount]",
                                format: "percent" //Specify the format here 
                            }], 
                    axis: "columns" 
                }
        ],
        this.filters= []
    }
}