Showing assigned fundraisers in a dashboard insight

Hello, everyone!


I have built a dashboard listing all of our gifts received within a certain time range, complete with constituent information on each row (name, ID, etc.). So far, so good! However, our team desired that each row should also list the fundraiser assigned for that constituent. By this point, the "fundraiser" name column was "hidden" in the report builder, not allowing me to access it (I'm still not actually sure what the rationale is for NXT revealing or hiding specific fields for building a report).


Therefore, I built the report again from scratch, making sure I could use "fundraiser name" before it got hidden (however, when I chose it, NXT hid other fields that I wanted to use, like "Pledge Installment Balance," for some reason).


That's where I hit another complication: As long as the report is purely about constituent data, "fundraiser name" gets its data from the fundraiser assigned to the constituent (located in the "assigned fundraiser" tab). But the moment any gift data is added to the report, like "gift amount" or "gift date," the "fundraiser name" field points to the fundraisers assigned to the gift, not the constituent.


What we'd really like to see is the name of the fundraiser assigned to the constituent record, even if the report is listing gift info. Is that possible? Does anyone have any wisdom to impart to a new guy like me?


Thanks a lot!