Sir_Lamancha
New Member
- Joined
- Aug 24, 2021
- Messages
- 2
- Office Version
- 365
- 2019
- Platform
- Windows
- Mobile
- Web
Hi Everyone!
I am looking at building a reporting pivot table that grabs my data from a large data set with about 700 column. Instead of making several pivot tables, I would like to be able to have 1 pivot table that I could change the to fit my needs to pull in the right columns and rows as well as filters. Is there a way to create something that would not be in VBA that could toggle certain preset pivots to populate the pivot table and switch back and forth? For example, if the vertical of the data set is houses, for one report I would like to see prices, SF, and filter by houses in the west then for another report, I would like to have see regions, how many have sold, what price, etc.
Thanks for your help in advance!
I am looking at building a reporting pivot table that grabs my data from a large data set with about 700 column. Instead of making several pivot tables, I would like to be able to have 1 pivot table that I could change the to fit my needs to pull in the right columns and rows as well as filters. Is there a way to create something that would not be in VBA that could toggle certain preset pivots to populate the pivot table and switch back and forth? For example, if the vertical of the data set is houses, for one report I would like to see prices, SF, and filter by houses in the west then for another report, I would like to have see regions, how many have sold, what price, etc.
Thanks for your help in advance!