Eliminate Duplicates, Return Only Highest Value

0_InventBeginBal_ForNetSuite.baq (19.0 KB)
I need to return ONLY THE HIGHEST “Item Cost” record from this BAQ.
It is only two columns with Item Cost being the secondary sort (descending) but I can’t seem to get it to work.

Any help would be greatly appreciated.

I didn’t download your BAQ because I’m not at work, but if I read your post right, you want only 1 row total returned from your BAQ? If that is the case, go to your subquery settings and change the drop down to top, the put 1 in the settings for number of rows. That should give you the first row. And if you have the order set right, it should be the one you want.

Take a look at this post is has some good tips