I thought this was going to be a bit simpler than I am finding. I have a list of over 300 funds with no easy way to group them (they span categories, are not all in the same type or anything). Those above me are wanting to know the largest and last gift to each fund with specific donor information for said gift. When I did a fund query to pull other information on the fund I was able to pull the Largest Gift, Latest Gift, and Total Given. However, those were just dollars; I need to know the specific gifts tied to Largest Gift and Latest Gift. Is there a way to grab that?
Basically, what I want to do is have a First/Greatest/Latest Gift Report but listed by Fund, not constituent. I still have no knowledge with Power Automate or anything so I am restricted to NXT skills, unfortunately. My only solution is dumping things into Excel and going from there but I was hoping there is something I just haven't considered. I tried a gift query and applying an output limit to the top rows but that did not work.