Forum Discussion
BriWork
Sep 22, 2023Copper Contributor
How to link pivot tables
Hi! I distributed a survey and aggregated the results in Excel where each question and it's answers is its own pivot table. I would like to make the same type of changes to all pivot tables (e.g. mov...
- Sep 22, 2023
BriWork You can read about slicers on my website: https://jkp-ads.com/articles/slicers.asp
JKPieterse
Sep 22, 2023Silver Contributor
Why not create just one PT with the Question as a page field (or as a slicer!)?
BriWork
Sep 22, 2023Copper Contributor
It's my first time working with PTs so I was unsure what to do as in the end I would also like to generate graphs of the responses to each question. I will look into page fields or slicers, since I haven't heard of them before.
- JKPieterseSep 22, 2023Silver Contributor
BriWork You can read about slicers on my website: https://jkp-ads.com/articles/slicers.asp
- BriWorkSep 22, 2023Copper ContributorThis is great, thanks so much!