I have to show top 3 vendors with pending balance in an email using Action flows. what PQL function can we use to sort top 3 vendors based on Amount column to apply same logic in Action flows?

Basically, these values are same as if we create OLAP table and sort by Amount, but these has to build in a single KPI component as 3 KPIs.