4.50
1
4.50
3.00
4
12.00
5.00
2
10.00
4.50
1
4.50
3.00
3
9.00
5.00
2
10.00
4.50
1
4.50
3.00
2
6.00
5.00
2
10.00
4.50
2
9.00
3.00
3
9.00
5.00
2
10.00
4.50
2
9.00
3.00
2
6.00
4.50
1
4.50
3.00
1
3.00
5.00
2
10.00
4.50
2
9.00
5.00
5
25.00
4.50
1
4.50
3.00
3
9.00
5.00
2
10.00
4.50
4
18.00
5.00
2
10.00
4.50
2
9.00
3.00
3
9.00
5.00
3
15.00
4.50
6
27.00
3.00
2
6.00
5.00
1
5.00
4.50
1
4.50
3.00
2
6.00
5.00
7
35.00
Martin
Cheryl
Guylene
Regina
Ian
Antoni
Andrew
Lars
Shelley
Nancy
Mayumi
Petra
Cappuccino
Sum
Count
Average
Caffe Espresso
Sum
Count
Average
Caffe Latte
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.