This is how my data looks:

635584 8/10/2012 Family Medicine Ba NP
635584 4/18/2013 Family Medicine Egan MD
635584 3/17/2014 Women's Health Prenatal Registration
635584 6/2/2014 Family Medicine Matathia
635584 8/5/2014 Women's Health Forman CNM

I want to only pull the latest appointment which was 8/5/14, I created the formula:
maximum({Command.lastappt}) and was able to do just that!

but I also got the providers too...

635584 8/5/2014 Family Medicine Ba NP
635584 8/5/2014 Family Medicine Egan MD
635584 8/5/2014 Women's Health Prenatal Registration
635584 8/5/2014 Family Medicine Matathia
635584 8/5/2014 Women's Health Forman CNM

So I went ahead and did this...
maximum({Command.lastappt}) & " " & {Command.provider}
and it gave me the same results.

It works the same way even if I group by Provider. What's the best approach?

Thanks in advance!