Pivot App: Running two pivots
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.