Pivot App: Running two pivots
Hello,
I want to use the Pivot app to filter two separate types of data. For example, I have a columns of primary stakeholders and secondary stakeholders. I want to be able to count the names of the primary stakeholders with their unique secondary stakeholders as well as the names of the unique primary stakeholders with their secondary stakeholders.
I tried multiple configurations in the Pivot app and can't seem to get it right.
Thanks!
Answers
-
I'm not sure I quite understand what you're looking to do - based on this description I would potentially suggest creating two separate Pivots instead of trying to combine your data into one export sheet, then use a Report to bring together both sets of data.
If this doesn't help, could you post a screen capture if your source sheet and a screen capture demo of what you would like the output to be? Please block out sensitive data in your images.
Cheers!
Genevieve
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives