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?