Videos tagged with pivot

Today’s question is a follow-up to yesterday’s question. How can you make sure that a pivot table shows you one row per day, even if there were no sales on a given day? Episode 592 shows two annoying solutions. If you have a better solution, please send in your ideas to bill @ MrExcel.com.

Say that you have a pivot table with region and product in the row area. If you would like a blank row between each region, or even a page break between each region, change the Layout properties for the field. Episode 503 shows you how.

In Excel 2002+, try to create a formula next to your pivot table. When you copy this formula down to other cells, the formula keeps pointing at the original cells! Is this a bug? No, it's a feature! Well, whatever it is, in Episode 377 I will show you how to stop the functionality so that things continue to work like they did back in Excel 2000.

Instead of creating Pivot Tables, create your summary as a flexible chart. Episode 294 shows you how to create a pivot chart.

Add a calculated field to a pivot table. Episode 292 shows you how.

Szilvia from California calls in today with a great question.... How could I have written an entire book on pivot tables and never mentioned the Show Pages feature? We will try it out on today's podcast and I have to admit, it is one of the cooler features in pivot tables. Basically, if you need to create a report for every customer in your database, you can do it with the Show Pages feature in...

I use this trick all of the time. Say that you have two versions of a list. You have the current version and an old version. You want to see what changed between the two versions. Rather than try to build complicated VLOOKUP formulas, use a simple pivot table to compare the two lists. Episode 290 shows you how.

Sometimes you need to take the results of your pivot table to another system. There are a few problems with the default outline view of a pivot table. First - the subtotal rows can get in the way, particularly when you have two or more fields in the row area. Episode 288 will show you how to remove subtotals from from a field.

While pivot tables are incredibly powerful, they generally look absolutely horrible. Rather than continuously formatting the pivot table after every change, you can use the Pivot Table AutoFormats on the pivot table toolbar. Episode 285 shows you how.

If you are trying to plan inventory in the warehouse or material scheduling at the manufacturing plant, you will want to create an order leadtime report. Episode 284 shows how to use a pivot table with two dates grouped up to months.