Make an Excel PivotTable with multiple or nested rows
Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.
A list with groupings (like Product Type, Country, Region or Staff pay level) can become a nested PivotTable. The sub-totals are created with + – signs to show/hide the groupings.
Doing that is simple, just drag a second item down to the Rows area:
Drill down more
Adding another row level lets you drill down even more. In this case to the date of each order.
Adding a date field will automatically group as well, in this case by Month. You can drill down from the top level (Category) to sales by month and finally sales per day.
If you don’t want the auto-grouping just choose the Remove Field option from the pull-down menu for the grouping eg ‘Months’.
Office Watch has the latest news and tips about Microsoft Office. Delivered once a week.