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?