I learned how to filter pivot tables in Google Sheets, using custom formulas: refer to column names instead of column letters. For example "Date" or "Price" instead of "A" or "B".