Bacon Bits:

Hi there! Remember me? I run a blog on Excel and Access. I’ve been away for a while doing some exciting stuff for lots of people. I can’t talk about any of it, but let’s just say it involves a plastic funnel and hotel soap.

.

Anyway, for my first post back, I thought it would be fun to do a light Pivot Table trick.

Did you know you can show more than one subtotal for a particular field in a pivot table?

In this example, I’ve got some information on the sales of bar equipment. Although we do see the sum of all sales at the bottom, let’s say we’d like to see a few more descriptive statistics (like avg, min, and max).
» More: Showing Multiple Pivot Table Subtotals for One Field

Did you know you can break up your PivotTable’s Report filters into multiple columns?

Take a normal PivotTable with multiple Report Filters (In this example – Region, Product Description, Business Segment, Customer Name).
» More: Break PivotTable Report Filters into Multiple Columns

Did you know that you can change the title of your PivotTable’s summary rows?

Most people don’t even try it, but customizing the Grand Total and other Summary titles give your PivotTables a little something extra.

» More: Renaming PivotTable Summary Field Titles