I just got off a very long and painful conversation about gift and constituent queries. Our communications manager (as well as other staff) would like to know the total amount raised for a particular workplace giving history, over the last 5 years. Apparently, this is completely impossible. Either I can run a gift query and pull all gifts with a specific appeal/package, but run the risk of pulling in gifts that are not specific to that package, and I also cannot see the total gift amount to that campaign later in export; or I can run a constituent query, but will run the risk of pulling in completely random gifts that are not what I'm looking for. This is so so important to know a comprehensive giving history, and I am beyond frustrated that this is not built into RE.