I am struggling to find out a way to exclude certain rows using column condition.
As an example, a summary table listed below, the first 5 columns are the group conditions that I use to get summary table.
I have to manually select and exclude the highlighted blue font row, because this Box is still in the machine and have not get to a full count of 100 as Max(Slot) showed.
Then this Box will continue serving for the next operation shift start and take out when it reach 100. So the highlighted box cannot be counted as a output for day.
Is there a way to select the row where the Max(dCreated) is largest # by putting Class, and Day column into group? Actually the table have have more than 100,000 of row and it is troublesome to do it manually.