I’m looking for help in sorting this table.
I want to sort the table so that it shows me any time I peak above 3. I thought it was an easy filter to filter count > 3. Turns out, I lose the rest of data in that row which I need because it’s not all above 3.
In this screen-shot, I’m only interested in row 3 because it has at least one value above my threshold. I want to filter out the other rows but keep the rest of the values in my row (the 1’s and nulls).
Any ideas would be appreciated.