Make your first Two-dimensional PivotTable in Excel


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

We started with a simple Excel PivotTable, now let’s move on to a multi-column or two dimensional PivotTables.  They aren’t a lot more complicated than a basic PivotTable, just add a few more fields.

We’ll start with the same sales list that we used for our PivotTables 101 article.  This time we’ll make a more useful PivotTable that shows more detail than a simple column.

make your first two dimensional pivottable in excel 15427 - Make your first Two-dimensional PivotTable in Excel

Let’s start dragging the following fields to the different areas as shown in the figure below.

  • Sales into the Values area.
  • Country into the Rows area
  • Product fields into Columns area

The first three (Rows, Filters and Values) are the same as the ‘one-dimensional’ example.

What makes this a better ‘two-dimensional’ PivotTable is the addition of the ‘Columns’ .

Making a ‘2D’ Excel PivotTable just means there’s data fields in both the Rows and Columns elements.

make your first two dimensional pivottable in excel 15430 - Make your first Two-dimensional PivotTable in Excel

That’s all you got to do. The difference is adding a field to the ‘Columns’ area in addition to Rows and Values.

Check out the following figure of the two-dimensional Pivot table:

make your first two dimensional pivottable in excel 15429 - Make your first Two-dimensional PivotTable in Excel

The two-dimension version breaks up the sales by country and product.

subs profile e1563205311409 - Make your first Two-dimensional PivotTable in Excel
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address