Act on filtered table

Consider the following table:

I’d like the ‘Minimum’ and ‘Maximum’ columns to only include the currently filtered rows for evaluation.

In this example, the weight of “Cherry” (filtered out) should not be considered in calculating the min/max values (just like in the summarize row at the bottom of the table) and therefore the ‘Minimum’ column should read (40, 40, 40).

I know how to hardcode this, but is there a way to make this work regardless of the applied filter? Is there a way to test if a data row is visible in the current view?

1 Like

Create an external formula for the filter, then use that same formula to filter the view and inside the columns formulas.

I was hoping for way that works without an “external” filter function, but thanks for taking the time to reply!