Category: Pivot Table

how to plan a pivot table 4

How to Plan a Pivot Table in Excel

Setting up a pivot table is a bit like news reporting – you can give a quick summary of the Who, What, When, Where and How (Much) of your data. After you’ve been using...

Excel Pivot Table Show Details 1

Pivot Table Show Details Sheets

When you double-click on a pivot table value cell, Excel creates a new sheet, with a list of all the records that make up that total value. The double-click runs Excel’s Pivot Table Show...

unpivot excel data 4

Quick Ways to Unpivot Excel Data

Before you can build a flexible pivot table, you might need to rearrange the data. For example, if the data has a separate column for each month’s sales, that won’t work well in a...

How to Create a Pivot Table Style 0

How to Create a Pivot Table Style

You don’t have to stick with the default formats for your pivot tables. You can create a pivot table style with your own colours, and other formatting options that you like. Here’s how to...

pivot table time rounding 4

Pivot Table Time Problems

It’s pivot table time! First, we’ll take a look two common pivot table time problems – rounding and totals. Then I’ll show you a couple of ways to save time when working with pivot...

Distinct Count in Pivot Table http://blog.contextures.com/ 11

Count Unique in Excel Pivot Table

In a previous article,  Roger Govier showed us a couple of different ways to get a Unique count with a Pivot Table. Create a Pivot of a Pivot Tables results (fast) Add a calculated...

Fix Pivot Chart Column Colors http://blog.contextures.com/ 0

Change Pivot Chart Layout

Recently, someone asked me why all the columns in their pivot chart were the same colour. The chart showed several months of data, for multiple regions, and every column was blue. In the screen...