Is there anyway to select the record with the latest date of the group and show it in a report?

Question

I have a set of records that have a date field and are part of different groups. Is there anyway to select the record with the latest date of the group and show it in a report? So instead of 12 groups with 10 records each. I only see 12 groups with 1 record each.

------------------------------
Logan
------------------------------

markshnier__you · Answer

np,
Make a report of type "Summary" (ie not a table Report)

Summarize Date by Maximum and Group by "Group".

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

loganlott2 · Answer

Ah got it. Thanks Mark------------------------------Logan Lott------------------------------

Forum Discussion

Is there anyway to select the record with the latest date of the group and show it in a report?

Related Content

Multi-Select Fields with Commas in Pipelines

If Then Else formula with a multi select field.

Summary report w/multi-select field

Restful API Report digesting JSON

Checkbox Fields Vs Multi-Select Fields for Tracking