I have a table of data where each row is a unit produced, and each unit has a failing pin which is denoted in a FAILING_PIN column. What I want is a column that summarizes the number of units with each failing pin number. So let's say I have 250 units that had pin 5 fail. Each of their FAILING_PIN column would say 5 and the column I want would say 250.
What I want can be done by using the tabulate or summarize options and then merging the result back to the original table, but I want the number to update as I filter the table. So if I select 50 of those 250 units and mark them as hidden, the column will update to 200 rather than just having the static number that I merged back. What is the best way to achieve this? The formula column feature seems to only operate on an individual row.