Im having a little delemma, I just cant figure it out, I think it is just a simple slice,
Im looking to take a table of lot numbers with a virtual column that is always calculating the stock of the lot, and take away all the duplicate rows as seen below, I dont know what wrong atm, tried allot of things.
I just want to get all the duplicate rows of Lot Number. So im only showing an overview of the final results. 1 row, per lot number.