Author Archives: Debra

New Pivot Items at End of List

Why do new pivot items appear at the end of the lists, when you add them to an Excel pivot table? It’s hard to find those new items, if they aren’t sorted alphabetically. Keep reading, to see why that happens, … Continue reading

Posted in Sort and Filter | 1 Comment

Distinct Count in Excel Pivot Table

When you create a pivot table to summarize data, Excel automatically creates sums and counts for the fields that you add to the Values area. In addition, you might want to see a distinct count (unique count) for some fields, … Continue reading

Posted in Calculations | 4 Comments

Excel Pivot Table Grand Total Headings

When a pivot table has grand totals, Excel automatically names those totals. I’ll show you some examples, with details on which grand total headings you can change, and which ones you can’t.

Posted in Group and Total | Leave a comment

Quickly Change Pivot Table Layout

Pivot tables are a quick way to summarize your data, and they have another advantage too. After you build the pivot table, it’s easy to change pivot table layout, to get a different type of summary. Watch the video below, … Continue reading

Posted in Excel Pivot Table | Leave a comment

Unpivot Excel Data With a Macro

If you plan to build a pivot table, check the source data first, to make sure you have it set up correctly. If there is a heading for each month’s sales, instead of just one column where all the amounts … Continue reading

Posted in Excel Pivot Table | Leave a comment

Remove Sum Of From Pivot Table With Macro

When you put value fields into a pivot table, it automatically adds  text to the headings, such as “Sum of Quantity”, if the field name is Quantity. You can manually change those headings, to remove the extra text, if there … Continue reading

Posted in Layout | Leave a comment

Show Tenths of Second in Pivot Table Times

If you try to show hundredths of second, or tenths of second in pivot table, you might have trouble. Usually, the times are rounded, and there is a zero, instead of numbers, for the tenths and hundredths. See how to fix … Continue reading

Posted in Formatting | Leave a comment

How to Fix a Pivot Chart All Columns One Color

After you create a pivot table, you can insert a pivot chart, based on that pivot table. In this example, the chart shows sales data, per city, over two years. See how to change the chart layout, after you build … Continue reading

Posted in Pivot Chart | Leave a comment

Pivot Table Top 10 Filter From Worksheet Values

Top 10 Filters are a quick and easy way to focus on key items in a pivot table. Instead of looking at all the data, hide everything except a set number of top or bottom items. In the screen shot … Continue reading

Posted in Sort and Filter | 4 Comments

Change Pivot Table to Outline Layout With VBA

When you create a new pivot table in Excel, it uses the Compact Layout, by default. That layout has all the row fields in a single column, with each field slightly indented from the previous field. You can read more … Continue reading

Posted in Layout | Leave a comment