Generate calculated table containing rows where count of a value is greater 0 for each user

For your question "so then it would be a record count? (since the field is true/false) meaning that if 0 contacts you want to count False and only false?".

Almost - I need the list of users that have False for EVERY contact_method.

Another way to look at it (I've added the campaign column in this example - just for context since this table is tied to others via the campaign:

TABLE_A:

campaign  user_id       contact_method   confirmed

X              123            email                  False

X              123            text                    False

X              321            email                  True

X              321            text                    False

So for my calculated table, I'm looking to get the following result:

campaign  user

X              123

I felt it would be kind of odd to stick a calculated column in TABLE_A, because whle the data exists in TABLE_A to determine which users did not confirm at all, I tend to think of keeping calculated/summary data separate from non calculated.