Get most recent item in each group in a list

%3CLINGO-SUB%20id%3D%22lingo-sub-2819601%22%20slang%3D%22en-US%22%3EGet%20most%20recent%20item%20in%20each%20group%20in%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2819601%22%20slang%3D%22en-US%22%3E%3CP%3ESharepoint%202016%20on%20premises%3C%2FP%3E%3CP%3EI%20have%20a%20weekly%20reports%20list%20that%20is%20grouped%20by%20Location.%20I%20need%20to%20get%20the%20item%20with%20the%20most%20recent%20Report%20Date%20for%20each%20Location%20(group)%20on%20a%20web%20part%20page.%20I%20figure%20I%20should%20be%20able%20to%20do%20that%20with%20Content%20Search%20WP%20or%20Content%20Query%20WP.%20Some%20locations%20may%20go%20several%20weeks%20between%20activity.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2819601%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Sharepoint 2016 on premises

I have a weekly reports list that is grouped by Location. I need to get the item with the most recent Report Date for each Location (group) on a web part page. I figure I should be able to do that with Content Search WP or Content Query WP. Some locations may go several weeks between activity.

0 Replies