Exceljet

Quick, clean, and to the point

Pivot Table Examples

Overview | Why Pivot? | Tips | Examples | Training

Pivot table basic count

Pivot table basic sum

Pivot table calculated field example

Pivot table calculated item example

Pivot table conditional formatting

Pivot table count birthdays by month

Pivot table count blanks

Pivot table count by month

Pivot table count by year

Pivot table count with percentage

Pivot table display items with no data

Pivot table filter by weekday

Pivot table group by age

Pivot table group by custom

Pivot table group by day of week

Pivot table group by quarter

Pivot table issue count by priority

Pivot table last 12 months

Pivot table last 4 weeks

Pivot table last 7 days

Pivot table latest values

Pivot table list unique values

Pivot table month over month

Pivot table months with no data

Pivot table most frequently occurring

Pivot table project estimate

Pivot table rank example

Pivot table remove deleted items

Pivot table running total

Pivot table show duplicates

Pivot table show top 3 values

Pivot table sum by month

Pivot table two-way average

Pivot table two-way count

Pivot table two-way sum

Pivot table unique count

Pivot table year over year

Pivot table year over year by month