Group By Global dimension 1 then by companies

Hello
I would like to know how I can perform the following using the NL function
From a NAV database- to group by the Global Dimension 1 (List from dimension Values table.) and same time getting the Entry No from the cust ledger entry table for filters with matching Global dimension 1 + document type as payment + from all companies within the database.

Thanking you.