3.30
2
6.60
3.00
2
6.00
1.75
4
7.00
3.30
1
3.30
3.00
4
12.00
3.30
4
13.20
1.75
3
5.25
3.30
2
6.60
3.00
2
6.00
1.75
2
3.50
3.30
4
13.20
3.00
3
9.00
1.75
2
3.50
3.30
3
9.90
3.00
5
15.00
1.75
2
3.50
3.30
2
6.60
3.00
3
9.00
1.75
3
5.25
3.30
3
9.90
3.00
3
9.00
1.75
1
1.75
3.30
3
9.90
3.00
1
3.00
1.75
4
7.00
3.30
3
9.90
3.00
1
3.00
3.30
3
9.90
3.00
2
6.00
1.75
1
1.75
3.30
4
13.20
3.00
3
9.00
Antoni
Ian
Cheryl
Mayumi
Lars
Martin
Shelley
Nancy
Peter
Michael
Beate
Petra
Caffe Espresso
Sum
Count
Average
Doubleshot Espresso
Sum
Count
Average
Espresso Truffle
Sum
Count
Average

Description

This is an example of Pivot Grid with custom style of the grid cells depending on their current value. You can change the rendering of any cell, row or column and insert your own HTML content by implementing the itemsRenderer and cellsRenderer functions. In this case, the custom code simply chooses among five predefined colors and sets the backgroundColor property of the cell content. This color customization is applied only to the cells with 'Sum' aggregation function. You can change the code of the itemsRender and cellsRenderer functions and implement your own customization logic using standard HTML and CSS.