How can I filter or summarize a text field in a portal?

Version 1



    I have a self join relationship table to create a portal in my layout. but I don't know how to summarize or sub summarize a text field so it will appear only one record each category will show. Anyone can help please.


    Table1        Table 2

    Supplier = SupplierJustone.jpg