Monday, October 17th, 2016
Written by Jane Hames
If you use Excel to summarise and analyse data with pivottables, there may be some very useful options that you haven’t yet discovered (because they are fairly well hidden!). One such feature is the PivotTable Report Pages option. If you are using a report filter (you will have a field name in the Report Filters/Filters part of the pivottable layout box, you have the ability to filter the pivottable without having to show that field in the pivottable itself. See example below:
In my example, as shown above, I would like to have a separate worksheet with its own pivottable for each of my customers. The Show Report Filter Pages options will do this in a flash! Here’s how:
If you would like to learn how to use PivotTables from scratch or just to learn more about Excel please do get in touch.
Written by Jane Hames
If you use Excel to summarise and analyse data with pivottables, there may be some very useful options that you haven’t yet discovered (because they are fairly well hidden!). One such feature is the PivotTable Report Pages option. If you are using a report filter (you will have a field name in the Report Filters/Filters part of the pivottable layout box, you have the ability to filter the pivottable without having to show that field in the pivottable itself. See example below:
Read more on Show PivotTables over separate sheets using Report Filter Pages…