Thee Excel pivot table may be the best tool in the market for creating ad hoc report. We can very rapidly compare data from various angles. 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: SUMIFS AVERAGESIFS COUNTIFS 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. The examples are based on a dataset. Examples and dataset you can download. In the dowload it is easy to see how I used the different functions. 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...
Blog over software als Access, Excel, SQL, Crystal Reports, Report Builder, Word, VBA, elfstedentochten en andere regionale zaken.