Google Sheets - Pivot Table: how to use sum(values) in filter custom formula

Question

In our attendance spreadsheet present is 1 and absent is 0. In a pivot table we show the attendance per person: sum(attendance). We only want to show people who attended sessions, so we want to filter out people with sum(attendance) = 0. I try to filter with a custom formula, but I can't find examples how to use sum in a custom filter. This doesn't work: = sum(attendance) > 0

How do I get it right?

Answer 1

The filter must be based on attendance, not on its sum. So it will simply be:

=attendance > 0