# Pivot Table Formula Templates

## Calculated Field Syntax

```
= 'Field1' / 'Field2'
= 'Revenue' - 'Cost'
= 'Quantity' * 'Unit Price'
```

## Common Calculated Fields

### Profit Margin

```
= 'Gross Profit' / 'Revenue'
```

### YoY Growth

```
= ('Current Year' - 'Prior Year') / 'Prior Year'
```

### Per Unit Metrics

```
= 'Total Value' / 'Quantity'
```

## Value Field Settings

- Sum (default for numbers)
- Count (default for text)
- Average
- Max/Min
- StdDev
- Distinct Count (requires Data Model)

## Date Grouping

Right-click date field → Group:

- Days
- Months
- Quarters
- Years

## Slicer Connection

Right-click slicer → Report Connections → Select all related pivots