Category: Pivot Table

Remove Excel Pivot Fields With Macros 7

Remove Excel Pivot Fields With Macros

If you’re rearranging a complex pivot table, it can take a while to manually remove each field. To make the job easier, you can remove Excel pivot fields with macros. There’s a sample macro...

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...