There’s no setting that lets you show the grand totals at the top of an Excel pivot table. But watch my short video below, to see a quick trick, to get around that limitation!
Continue reading “Video: Show Excel Pivot Table Grand Totals at Top”
Quick Pivot Table Filter Trick: Hide or Show Items
Pivot tables let you summarize thousands of rows of data, with just a few clicks. If you want to focus on a specific part of that summarized data, here are a couple of pivot table filter tricks.
Continue reading “Quick Pivot Table Filter Trick: Hide or Show Items”
Customize Your Excel Pivot Table Field List
The Excel Pivot Table Field List helps you build and modify your pivot tables quickly. But you don’t have to stick with its default settings! See how to change the Pivot Table Field List settings, so it works best for your needs.
Continue reading “Customize Your Excel Pivot Table Field List”
Make a Clustered Stacked Column Pivot Chart in Excel
Excel doesn’t have a built-in Cluster Stack chart type, but you can make one, with a quick pivot chart.
See how to make the chart shown below, with stacked columns, grouped into regional “clusters”.
Continue reading “Make a Clustered Stacked Column Pivot Chart in Excel”
Is Excel PIVOTBY Function Better Than Pivot Tables?
Do you love Excel pivot tables? And have you tried Excel’s new PIVOTBY function?
With just one formula cell, PIVOTBY can summarize annual sales by year, region, and category!
But is PIVOTBY better than Excel pivot tables?
Continue reading “Is Excel PIVOTBY Function Better Than Pivot Tables?”
Make Pivot Chart Title Change with Filters
Instead of adding a static title to your Excel pivot chart, use a worksheet formula to create a dynamic chart title. When you change a pivot table filter, the chart title updates automatically, to show what you selected!
Continue reading “Make Pivot Chart Title Change with Filters”
Fix Pivot Table Problem – Cannot Group That Selection
In an Excel pivot table, if you try to group a date or number field, you might see an error message. The message box shows a yellow warning label, and the text says, “Cannot group that selection”.
Continue reading “Fix Pivot Table Problem – Cannot Group That Selection”
Wrong Item at Top of Sorted Pivot Table in Excel
After you sort an Excel pivot table, the wrong item might appear at the top of a column. For example, in the screen shot below, the list of Sales Rep names has Jan at the top. Below that name, all the other names are sorted in the correct alphabetical order.
Continue reading “Wrong Item at Top of Sorted Pivot Table in Excel”
Make Your Pivot Table Look Better – 3 Quick Tips
Do you ever make a quick pivot table, then spend the next 30 minutes trying to make it look good? Here are three quick pivot table layout tips, to make your job a bit easier!
Continue reading “Make Your Pivot Table Look Better – 3 Quick Tips”
How to Sort Pivot Table Report Filters
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!