topic Formula for Filter Pane to Apply to 2 Columns in App Development

Formula for Filter Pane to Apply to 2 Columns

joshdellapietro — Tue, 14 Sep 2021 22:27:08 GMT

Hi All,

I have two columns, [Customer 1] and [Customer 2], they share 4 of the same members; 'Member A', 'Member B', 'Member C', and 'Member D'.

I have multiple charts on my sheet, some pertain to [Customer 1], some to [Customer 2].

Using a Filter Pane, I am trying to create a formula that shows only the 4 common members (A-D) and when one is selected, the filter applies to both [Customer 1] and [Customer 2].

Please help!

Re: Formula for Filter Pane to Apply to 2 Columns

rbartley — Wed, 15 Sep 2021 10:47:13 GMT

It seems to me as though you need to alter your load script to include a link table which includes the common customer values and use the field from this table in your filter pane.

Re: Formula for Filter Pane to Apply to 2 Columns

stevejoyce — Wed, 15 Sep 2021 11:25:02 GMT

I'd probably agree with @rbartley. But this should give you what you want: this will only show where values exist in both customer fields and selects the value in both fields:

=aggr(if([Customer 1] = [Customer 2], [Customer 1] ), [Customer 1] , [Customer 2])