Data formatting of the pivot table

Webix JS
1

Hi,
How can I show formatted data in the pivot table. Like I would like to show 1,234 instead of (1234) or flooring or ceiling the data (instead of 1.78 show 2 or instead of 1.25 show 1)

2

Hi,

you can set “format” property in value definition, for example as in:

values: [{name:"gdp", operation:"sum", format: webix.Number.format}]
3

Thanks it worked!!

4

Hi Maria, I’m using the approach you describe to apply formatting to number values in my Pivot Table.
The problem I have now is that every time I use the “Configure” tool, even if I don’t change anything and just click “Apply”, my number formatting is lost.
Any suggestions to solve this issue?
Thanks.

5

Hi @ignaciopq,

The above solution suits for the initial formatting. After setting the new configuration, the previous one will be lost.

To preserve the format, CSS or some template, you can use onBeforeRender event and specify the needed column property. In the following sample, it will affect the entire Pivot:

http://webix.com/snippet/70f8b4ec

6

You can define format for the pivot as well.
This one for example rounds the values to two decimal digits and sets the numberFormat
https://snippet.webix.com/6iy3y7vv