In the attached spreadsheet I am looking at schools that have entered their pupils to study maths and sit an exam at either GCE or GCSE level. I have shown how many children they entered across the last three years and I'm showing this in the columns. Is there any way to filter the values in column E so it is only showing the schools with '0'. I haven't been able to do this so far.
Many thanks in advance.
Hi EA,
Perhaps using the Bottom 2 schools Values is what you need? See the attached:
Bottom Two Schools Filter.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
You could add a Slicer and select the zero amount. See attached
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you Marvin and Richard. Both of those suggestions would usually work but I need to still be able to see the GCSE data. I'd want it to look like this:
Attachment 775686
Selecting Attachment 775686 results in the following message: "Invalid Attachment specified. If you followed a valid link, please notify the administrator".
Please utilize the information in the banner at the top of the page to put a mockup of your expected GCSE data in an Excel file.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Sorry about that. Can you see it now?
Attachment 776499
I get the same message as before.
That's strange, I'm simply clicking import image. Will try importing as an attachment. As you can see in the pivot table it is showing both the GCSE and the GCE columns. To get to this I filtered by the school names but when I'm doing this for real there will be 100's of schools so it won't be practical to do that.
Last edited by Excel_apprentice; 04-12-2022 at 10:50 AM.
A low-tech proposal would be to add a column to the source data that will return true/false based on the sum of the GCE entries being zero.
The formula for the helper column is: =SUMIFS([Entries],[School name],[@[School name]],[Level],"GCE")=0
The new column is then used as a filter for the pivot table without having to filter by school names.
Let us know if you have any questions.
Love this. Thanks.
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks