Hi,
I hope you can help as I've searched quite a lot...and no results.
I am looking for a way to set a pivot table filter that applies more than one criteria (or any solution that is functionaly equivalent).
The concrete case:
I have data (from a survey) with 4 columns:
- Response ID
- Organisation
- Question
- Score
I am using a pivot table to summarize data and give me the average scores for each organisation.
I need to have only the organisations with the Top 10 average scores, so I've used one of those Top 10 "Value Filters" and it works fine.
Now, some of the organisations have a very small number of responses, so I want to exclude those from the Top 10.
So, I would need to have two simultaneous "value filters":1) "Count of Score" Greater Than xxx AND 2) Top10 item by "average Score"
But I can't find a way to set both criteria...either one or the other...
Can you help me?
cheers,
miguel
Bookmarks