We need to be able to report on the amount under discussion (the total for proposals assigned certain statuses from our dropdown) for a campaign and the amount funded per campaign, and include the campaign targets and amount remaining to achieve.  We can link the gifts and proposals to the campaign but cant pull in this data in a campaign query.

Its very frustrating as would be an ideal method of summarising our pipeline and funding per campaign.