As soon as we are dealing with standard reports, reports with a longer time span and standardized results, I personally think the pivot table is less suitable as a reporting instrument.
In that case I prefer Excel functions like:
To build reports like this is definitely more complex and time consuming. In return you get longer lasting reports.
In the following example I created three examples to compare SUMIFS, AVERAGEIFS and COUNTIFS to the similar pivot tables.
Even in these relatively simple examples you can see an important diffenence. If you select a specific country the left examples still show all rows and columns. Some rows and columns disappear from the pivot table.
You can download the file ExcelPivotTableDifferent.xlsx via: