Excel Pivot Tables – by contextures.com

If you have a report filter at the top of your pivot table, do the items in the drop down list ever appear out of order? That happens in my pivot tables occasionally, and there isn’t a quick and easy way to fix the problem! Video: Sort Pivot Table Report...

After you create an Excel pivot table, the source data usually changes. New records are added, and old records might be changed or deleted. Later, when you refresh the pivot table, you should see a summary of your updated data, but sometimes there’s...

It’s easy to get a sum in a pivot table, or a total count. But how can you count unique items in an Excel pivot table? For example, if you’re analyzing sales data, you might need to show these types of counts: –How many unique products were sold in each...

If you add times to an Excel Pivot Table, and format the time to show tenths of a second or hundredths of a second, zeros might appear after the decimal point. The decimals for tenths of a second or hundredths of a second are rounded to zero, and changing...