Advanced Layout Demo

This example contains 5 layouts of different kinds:

  1. Simple Layout: a basic layout but which includes a Calculated Column (Avg Item Cost) and a FreeText Column (Comments)
  2. Sorting Layout: a layout which contains 2 sorted columns, one of which has a Custom Sort (ShipVia)
  3. Grouping Layout: which groups on the Employee and Ship Country columns
  4. 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)
  5. Advanced Layout: bit of everything
AdapTable Help Resources:

Generating dummy data, please wait ...