Hi @kom,
Okay, I've got something for you. Here's what it can look like:
![gdf.gif gdf.gif](https://community.jmp.com/t5/image/serverpage/image-id/30686i45964C50DDC4C04E/image-size/large?v=v2&px=999)
ā
It might say "Local Data Filter," but that's actually a Global Data Filter in that dashboard, and as such, will update row states (selections) when it's modified so that your selection formula operates. How did I do this? One tiny change in the script that JMP generates. But first, I built the dashboard as that video showed:
![julian_1-1614205524448.png julian_1-1614205524448.png](https://community.jmp.com/t5/image/serverpage/image-id/30681i42A058FE2B872467/image-size/large?v=v2&px=999)
Next, I ran that dashboard to make your almost-there version with a local data filter:
![julian_2-1614205587615.png julian_2-1614205587615.png](https://community.jmp.com/t5/image/serverpage/image-id/30682i455682370BF80079/image-size/large?v=v2&px=999)
Next, I saved the script of this dashboard to a script window, by using the Red Triangle for the dashboard:
![julian_3-1614205631582.png julian_3-1614205631582.png](https://community.jmp.com/t5/image/serverpage/image-id/30683iD41CB410683E335B/image-size/medium?v=v2&px=400)
On line 47, you will see the filter being defined:
![julian_5-1614205741324.png julian_5-1614205741324.png](https://community.jmp.com/t5/image/serverpage/image-id/30685i3C5A3AC6EB9CA311/image-size/large?v=v2&px=999)
Change Local to Global, and you're done!
![julian_6-1614205947242.png julian_6-1614205947242.png](https://community.jmp.com/t5/image/serverpage/image-id/30687i2834EEED1CC15F71/image-size/medium?v=v2&px=400)
I've attached your table here with the full script saved to the table. *Almost* no coding required
@julian