Hi,
How do I filter this module to display only the first occurrence of PR No (4th column).
PR No is text and its derived from using formula LEFT (PR List, 😎 .
PR List (the 1st column) is a composite list with material as a parent
Is there any way I can rank the lines with same PR Number (4th column) and filter to show only those lines ranked as 1

This is what I am trying to do... in the dashboard below (see first table) PR No 11943887 should only be shown once as a line
When the user select that line, another module i.e. the bottom table will display the many lines of PR 11943887 (eg 11943887-10-00, 11943887-20-00, 11943887-30-00 etc). with other details
The first table in dashboard is published from the module that I am trying to rank and filter without much success,
