Below shows a complex example making use of value getters (using expressions) and class rules (again using expressions). The grid shows 'actual vs budget data and yearly total' for widget sales split by city and country.
x_act) or budgeted (
x_bud) data for the month (eg.
jan_actwhen Jan is green, or
jan_budwhen Jan is red). Similarly, the background color is also changed using class rules dependent on the selected period.
Notice that the example (including calculating the expression on the fly, the grid only calculates what's needed to be displayed) runs very fast (once the data is loaded) despite having over 6,000 rows.
This example is best viewed by opening it in a new tab.