If you have to split a report by products, cities, employees, ... you can do it in one action with a pivot table 😉
Presentation of the problem
Let's say you have this data
I want to create a report of the sales by countries and then split this report by category of product.
Insert your data in a pivot table
So, let's create a pivot table with the countries and the sales
Create a filter
The secret lies with one option of the pivot table's filter.
At this step, we have no filter in our pivot table
When we drag-&-drop the field "Category" in the Filters area, automatically, a filter section is added above the pivot table.
Split the report
And now, here is the magic! 😎 Go to the menu
- Pivot Table Analyse
- Show Report Filter Pages
A new dialog appears and you select the field. Here there is only one filter 😉
AND THAT'S ALL! Automatically, your report is split for category. It's too easy 😎😍👍
And now, you have one worksheet for each item in the category field