MsDavid
New member
- Joined
- Jan 17, 2021
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 10 pro
I have a data set with 60 indicators for 58 companies for each year between 2017 and 2020. I need to analyse the data for each indicator based on 10 different ways of disaggregating the data. This would require about 1,000 pivot tables to present the analysis. How can I create multiple pivot tables with different rows, filters and values automatically or quickly? Or are there any other ways of speeding the process up, other than the ‘show report filter pages’ feature.