When I create a pivot table in Google Sheets, there is one Pivot Table Editor I can use to configure the pivot table.
The bottom of the editor's interface is filter (which allows me to add filters). If I add a filter, I have to select a column from the source data. After I have selected a column, I am able Filter by condition and Filter by values,
By values is simple enough – it presents a checklist. Under the condition works well with options like Contains text and Text ends with, But the last option in the by values List is Custom formula is, This option interests me, but is 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 reference the line in the source area of the pivot table to which the filter is applied? I did a test that I attend
= M3 = 5 and if I set the value 5 to cell M3 of the worksheet where the pivot table is located (not the worksheet that contains the source area), then the filter is all-passed, otherwise it is not passable. What is the meaning of it? How do I relate to the value of the cell in question? That would be very useful! Then I could use a formula like
= AND( and other such constructs, but at the moment it is (the Custom formula is Option) is almost useless.