DataGrid crosstab data support

Sometimes your data comes from crosstab queries and you need to present rows as columns.

In this demo a crosstab query groups Orders by Year and Company, calculates total amounts, then transposes years into columns to show two rows: one displaying company names and one showing amounts in currency format.