# PivotQuery

**Kind:** Constant

**Source:** `Pams/Web/Pams.WebApp/Client/app/models/dashboard/testCases.ts` (line 103)

**Part of:** [Pams](subsystem-pams)

## Definition

```ts
[{
    caption: 'Region',
    width: 120,
    dataField: 'region',
    area: 'row'
}, {
    caption: 'City',
    dataField: 'city',
    width: 150,
    area: 'row',
    selector: this.citySelector
}, {
    dataField: 'date',
    dataType: 'date',
    area: 'column'
}, {
    caption: 'Sales',
    dataField: 'amount',
    dataType: 'number',
    summaryType: 'sum',
    format: 'currency',
    area: …
```

## Value

```ts
[{
    caption: 'Region',
    width: 120,
    dataField: 'region',
    area: 'row'
}, {
    caption: 'City',
    dataField: 'city',
    width: 150,
    area: 'row',
    selector: this.citySelector
}, {
    dataField: 'date',
    dataType: 'date',
    area: 'column'
}, {
    caption: 'Sales',
    dataField: 'amount',
    dataType: 'number',
    summaryType: 'sum',
    format: 'currency',
    area: …
```