PDA

View Full Version : Pivot table showing results from multiple source columns



NiranNiran
2015-11-19, 09:13 AM
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).
[FONT=Calibri][SIZE=3][COLOR=#000000]For each option of answer (A

NiranNiran
2015-11-23, 08:21 AM
Sorry, this post is uncomplete but I seem to be unable to delete it. Please view the second post with the same title. Thanks.