Number Format

28 Sep 20172 minutes to read

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

<ej-pivotgrid [dataSource.values]="values">
</ej-pivotgrid>
//..
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= []
    }
}