I work with pharmacy claims, in which we often want to have a final report with only the most current fill reported.  We remove the duplicate claims, that have some different data and some matching, through using group filters in EG.   We also are non-coders.  The process is to pull the full data set first.  Then query off it, for our example, we first select to group by the Member ID, and GPI (unique drug identifier) - therefore keeping the combination of member + drug, regardless of the other information on the claim )such as costs, pharmacy, etc) and then we use the MAX summary function on the date field.  Once you have selected to do the MAX of date, on the filter tab, the "filter the summarized data" option will show up at the bottom half of the screen.   We then enter in the filter to this section where (CALCULATED MAX DATE) = DATE. This is probably a bit confusing to read through, but I think it's a really good way to get to the most recent data out of millions of rows of multiple transactions.  I would assume this would be helpful further than the Pharmacy industry. ... View more