Pivot App: Running two pivots

Nathan Umbriac

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!

Genevieve P.

Hi @Nathan Umbriac

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