Exceljet

Quick, clean, and to the point

Pivot Table Example - Voting results

In this example, we're going to analyze voting results with a pivot table.

How many people voted?
What was the winning vote?
What was the winning vote by percentage?
What's the breakdown by Gender?
What's the breakdown by Age?

In the data, we have the fields: Name, Gender, Age, and Vote.

And, you can see, that there are 3 voting options, A, B, and C.

First, how many people voted?

By counting Name, you can see we have 300 votes total.

Next, what was the winning vote?

The winning vote is Option B, with 156 votes.

What's the breakdown by Percentage?

Option A got 31%, Option C got 17%, and Option B is the winner with 52%

We could easily graph this with a pivot chart.

What's the breakdown by Gender?

By adding Gender ad a column label, we can easily get the full breakdown.

Finally, what's the breakdown by age?

To get a breakdown by age, we can group by number.

Now we have a clean breakdown by age in brackets of 10 years.

You can see that grouping by number is a powerful and cool feature.

Course 
Core Pivot

Related shortcuts

Author 
Dave Bruns