Advanced Layout Demo
This example contains 5 layouts of different kinds:
- Simple Layout: a basic layout but which includes a Calculated Column (Avg Item Cost) and a FreeText Column (Comments)
- Sorting Layout: a layout which contains 2 sorted columns, one of which has a Custom Sort (ShipVia)
- Grouping Layout: which groups on the Employee and Ship Country columns
- Pivoting Layout which defines the following pivoting definition:
- Pivot on the ShipVia column (the PivotColumns property) - note that we automatically uses the Custom Sort defined for that this column.
- Group on the Employee column (the GroupedColumns property)
- Show aggregation totals for the InvoicedCost (sum) and ItemCost (avg) columns (the AggregationColumns property)
- Advanced Layout: bit of everything
Generating dummy data, please wait ...