Find most recent transaction - Dataset View

swagner

I have a dataset with item receipt dates by branch. I need to find the most recent receiving event for each item by branch. The dataset has about 7M rows, and my thought was to do a dataset view, rank the receipts by branch & item descending on the receipt date. I can't seem to get the calculated column to work.

Any help would be appreciated.

rank() over(partition by Branch, Item order by Receipt Date desc)

jaeW_at_Onyx

@swagner why didn't you @ mention me? sorry so late to the party!

sum(sum(1)) over ( partition by branch, item order by receipt date desc)

shoudl work i believe.

swagner

@jaeW_at_Onyx thanks for the response! Much appreciated!