I hope this will be the definitive guide to pivot tables for anyone in this industry who has yet to feel one hundred percent comfortable with this crucial Excel feature.

If you wish to create a a Pivot Table and Pivot Chart in Excel, then this detailed article will guide you through the entire process.

In this case, you’ll need a second subtotal row. How to add a second subtotal row to a PivotTable in Excel The default PivotTable is useful, but you might need more information.

You can insert blanks rows above or below another in Excel, and you can even add them between each row that has data.