Select Page

Pivot Tables have a clever feature that allows you to drag multiple rows and columns to the same Pivot Table to add a whole new level of flexibility to your analysis. This video starts by showing you a way to clear all of the filters in a Pivot Table at once. We then add multiple rows to the same Pivot Table and see the difference between the outer row (on the far left) and the inner row (on the far right). Watch the way Excel handles subtotaling the rows based on which row is on the outside and which row is on the inside. The same trick works with columns, and with rows and columns together.