In below sample, I need select rows which number in column 'Index' is the maximum number of entire column 'Index'. i.e. in this example, I need select rows which number of 'Index' column is 8(lines marked in red). Is this possible in Alteryx with dynamic selection criteria?
Index | Name |
8 | Mike |
8 | Mary |
6 | Mike |
6 | Tom |
2 | Mike |
2 | Tina |
