Locked lesson.

## About this lesson

When you need to display a value as the % of another value on your PivotTable.

## Lesson versions

Multiple versions of this lesson are available, choose the appropriate version for you:

**2016**, 2019/365.

## Exercise files

Download the ‘before’ and ‘after’ Excel workbooks from the video tutorial and try the lesson yourself.

Percent of x Calculations.xlsx10.9 MB Percent of x Calculations - Completed.xlsx

10.9 MB

## Quick reference

### Topic

Display a value as the % of another value on a PivotTable.

### Where/when to use the technique

When you need to display a value as the % of another value on your PivotTable.

### Instructions

#### Accessing % of calculations

- Drag a value column onto the PivotTable
- Right click a cell in column you wish to convert to a % calculation
- Either:
- Choose Value Field Settings > Show Values As > the desired % of calculation
- Choose Show Values As > the desired % of calculation

#### % of Grand Totals

- % of Column Total: Expresses value as a % of the Grand Total row for that column
- % of Row Total: Expresses value as a % of the Grand Total column for that row
- % of Grand Total: Expresses value as a % of the Grand Total of the PivotTable

#### % of Parent

- % of Parent Column: Expresses value as a % of the parent field’s (sub)total for that row
- % of Parent Row: Expresses value as a % of the parent field’s (sub)total for that column
- % of Parent Total: Expresses value as a % of the (sub)total of the PivotTable

#### % of… (a specific field)

- To choose your base field, you need to decide if you’d like the % of to be calculated down a column or across a row
- Column: Pick a row field
- Row: Pick a column field

- % of can be set to:
- A specific item within a field (useful for comparing growth vs a specific year)
- The previous item (useful for comparing sales performance vs the prior month)
- The next item (useful for comparing forecast expectations)

Lesson notes are only available for subscribers.