NiranNiran
New member
- Joined
- Nov 19, 2015
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hi,
Is there a way that I can include multiple columns from my data source into one Pivot table?
I am able to use Pivot tables and create charts when one column is containing the data (e.g. answers to a questionnaire where respondents were able to choose only one answer among several, mutually exclusive answers).
However, I have questions where they were able to choose more than one Option (e.g. Person 1 ticked answer A, C and D; Person 2 ticked answer A, D, E and G).
For each option of answer (A
Is there a way that I can include multiple columns from my data source into one Pivot table?
I am able to use Pivot tables and create charts when one column is containing the data (e.g. answers to a questionnaire where respondents were able to choose only one answer among several, mutually exclusive answers).
However, I have questions where they were able to choose more than one Option (e.g. Person 1 ticked answer A, C and D; Person 2 ticked answer A, D, E and G).
For each option of answer (A