Can someone please tell me how can I get the nth row in Jet Reports?
I have tried using "LIMIT=", but it is not working. I am using the following query to get the 'Value Code' from 2nd row only using the query as following:
=NL("Last","Item Marketing Category Value","Value Code","Category Code","APPLICATION","Item No.","SCARLET792","LIMIT=",2)
But this is returning only last row. Please help me and tell me what query can I use to get just the 2nd row values?