Category: Pivot Table

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

Add Rank to Excel Pivot Table http://blog.contextures.com/ 1

Show Rank in Excel Pivot Table

A pivot table is a great way to quickly summarize number, to see how your business is doing. But sometimes those numbers are too large to analyze in your head, so let the pivot...

Move Pivot Fields Without Dragging http://blog.contextures.com/ 2

Move Pivot Fields Without Dragging

Last week, someone asked me if there is a menu command for moving the fields in a pivot table layout. For example, if the Region field is in the Columns area, can you use...

Pivot Table Data Source Tips http://blog.contextures.com/ 3

Pivot Table Source Data Articles

The key to success with Excel pivot tables is having good source data. I’ve written many articles with pivot table data source tips, and this list will help you find the information that you...

Use Excel Pivot Table Running Total Percent to Analyze Sales http://www.contextures.com/xlPivot14.html 0

Pivot Table Running Total Percent

At the beginning of every month, I download the previous month’s statistics for my web site, to see which pages and files were the most popular. After the data is imported to Excel, I...

alt text: Find and fix pivot table data source problems http://www.contextures.com/excelpivottablesourcedata.html 2

Find and Fix Pivot Table Source Data

After you create a pivot table, you might add or change records in the source data. Sometimes the pivot table does not update correctly, to show the new data. Or if you’ve inherited the...

Remove pivot table subtotals VBA http://blog.contextures.com/ 12

Hide Pivot Table Subtotals

Sometimes the Excel macro recorder creates code that gets you off to a good start. Other times, it’s not so helpful. This week, I was working on a pivot table macro, and wanted to...

Combine tables with Power Query http://blog.contextures.com/ 10

Combine Data on Two Worksheets

Have you been experimenting with the Power BI tools that are available in the newer versions of Excel. I’ve done some work with Power Pivot, and was impressed by what could be done with...