Pivot number format
You can use the numberFormat function to set the data to be displayed on the pivot in integer or decimal form.
Pivot number format
You can change it directly when setting the value field on the pivot setup screen.
When you click the button, the first decimal place is displayed.
pivot.setFieldMapping([
{
name: "Sales Quantity",
sourceField: "Sales Quantity",
numberFormat:"#,##0.0",
labelEnable: false
},{
name: "Vehicle price",
sourceField: "Vehicle price",
numberFormat:"#,##0.0",
labelEnable: false
},
...
]);When you click the button, the first decimal place is displayed.
pivot.setFieldMapping([
{
name: "Sales Quantity",
sourceField: "Sales Quantity",
numberFormat:"#,##0.00",
labelEnable: false
},{
name: "Vehicle price",
sourceField: "Vehicle price",
numberFormat:"#,##0.00",
labelEnable: false
},
...
]);