3.50
4.00
3.00
2.38
2.50
2.25
2.38
2.50
2.25
3.05
3.60
2.50
2.88
4.00
1.75
3.05
3.60
2.50
3.00
4.50
1.50
4.00
5.00
3.00
2.53
3.30
1.75
3.00
4.50
1.50
3.13
3.25
3.00
2.63
3.00
2.25
3.63
4.00
3.25
Germany
France
United States
Italy
Spain
Finland
Canada
Japan
Brazil
United Kingdom
China
India
South Korea
cells left alignment
cells center alignment
cells right alignment

Description

This pivot grid example demonstrates how to change the alignment of the values displayed in the pivot grid cells. The default behavior is to align the values to the right side of the grid cells. To change the default cells alignment, use the formatSettings align property during the definition of the value fields of the pivot grid. In addition to cells content alignment, the formatSettings object allows you to specify how to format the numbers displayed in the pivot grid cells. For example, you may change the number of digits after the decimal point, the thousands separator, whether negative numbers will be displayed in brackets or with a minus sign, as well as custom prefix and sufix text.