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...
Forum Discussion
Could you please clarify what prevents you to add Questions field to filter area of PivotTable? I assume all your source data is in one range.
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.
