Creating a report using table visual with lots of column used.In that i need to use a rank function like sql query which is showed below.
Rank() OVER(PARTITION BY table."policyno"
ORDER BY table."Loc_no" DESC ,table."vers_no" DESC
Is it possible?