In Google Sheets, if I create a pivot table, there is a Pivot table editor I can use to configure the pivot table.
The lowest section of the interface of the editor is Filters (which allows me to add filters). When I add a filter, I have to choose a column from the source data. Having chosen a column, I am able to Filter by condition and Filter by values.
By values is easy enough - it presents a check list. By condition also works fine with options like Text contains and Text ends with. But the final option in the by values list is Custom formula is. This is the option that is of interest to me, but it is also not fully documented on the help page (https://support.google.com/docs/answer/7572895?hl=en)
What is the syntax of the formula? How do I refer to the row, in the source range of the pivot table, to which the filter is being applied? I have done a test in which I enter
= M3 = 5 and if I put the value 5 in cell M3 of the sheet in which the pivot table sits (not the sheet in which the source range resides), then the filter is all-pass, otherwise it is no-pass. What is the point of that? How do I refer to the value of the cell in question? That would be very useful! Then I could use a formula like
= AND(<val>!="Financial", <val>!="Income") and other such constructs, but at the moment it (the Custom formula is option) is almost useless.