Pivot table filter to show (distinct?) count

I often create pivot tables that show responses to surveys. The Rows are generally built using Response Date, Question, and Response (verbatim comments).

We are trying to protect clients' anonymity so we only allow our charts to show data with 3+ responses (that way they can't filter down to the individual level and figure out who said what)

"Response ID" is what we use as an identifying factor --- A random number we generate for every response that we can tie back to their personal information.

This is easy enough to do on charts (Filter - > Exclude "Response ID" where the Distinct count range is < 3)

However, I have not been able to figure out how to successfully filter to hide data with less than 3 responses when using a pivot table.

When I try to put in a filter like I would with the graphs, it hides everything (simply shows "No Data"). It seems to be viewing each response as an individual entity, so instead of counting up the number responses and hiding those questions with less than 3 responses, it seems to be thinking "There is one question and one response in this row. That is less than 3. It should be excluded."

I unpivot the data using SQL, and build all of the charts off of this SQL. This creates a unique row of data for every question/response set (meaning one Resposne ID will have many rows of data), versus one row per Response ID with multiple question/answers.

Does anyone know how to properly filter pivot tables in the way I need and/or how to build an aggregate formula and/or a different way to arrange my SQL that would be able to work around this?

Access your files securely from anywhere

Zoho Developer Community

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Tout forum

France ZUGs

Zoho SalesIQ Resources

Sticky Posts
Announcing Zoho Analytics 6.0 Beta!
We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics team
What's New in Zoho Analytics - August 2024
Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the data
We are coming to your city! Zoho Analytics Community Meetup
Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructing
Zoho Analytics: 2021 Look Back
As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021
[Customer Talk] PREMO Group's Analyst Interview at Zoho Day 2022
Premo Group, a 50 year old Spanish Manufacturing Company, has been our long-standing customer with #ZohoAnalytics. They've been using our platform for their end-to-end, unified business analytics solution. Hear more from Claudio Cabeza, Director at PREMO