Forum Discussion
Filter by question in Pivot Table
I'm building out pivot tables for a survey which is essentially a series of Likert based questions. So all 20 questions in this survey have responses from Strongly Disagree to Strongly Agree. Es...
Hi Sergei,
Thanks for the quick response. The pivot table doesn't seem to be allowing me to add the questions into the filter column.
Every time I add one of the questions in the Field Name box to Column, it doesn't allow you to put it into Filters. When you add other questions into the Column box, it ends up creating a table within a table per the second screen shot.
Any help would be amazing.
Your data is not suitable for a pivot table.
Your source data is in a crosstabular format. It has to be changed into a data set list.
