I have used the following cross-tab query to get the total amount of contributions per project per year:
TRANSFORM Sum(ProjectContributions.USDAmount) AS SumOfUSDAmount
FROM ProjectContributions LEFT JOIN Projects ON ProjectContributions.ProjectID = Projects.ProjectID
GROUP BY ProjectContributions.ProjectID
Now what I'd like to do is spread the value of all contributions for a project across the years of the project by
multiplying the total project value by the percentage of the project's lifespan that falls in a given year.
It seems to me that it might be possible to write a query to do this, but I can't figure out how to get it to show all
Get the data showing in the query the way you like before it gets pivoted. If you want to show more than one value, like a total contribution and a count of contributions for each cell, then you may find it easier to program it to store into a table.