Hello! Is there a way to show last fiscal year's contribution total in a pivot table that is showing contributions for this fiscal year-to-date compared to last fiscal year-to-date? I'm doing the this year to last year comparison with the PASTYEAR function, but I'm not sure how to compare this year's current totals to last year's year-end totals.
(Bonus if I can also throw in a comparison to the last 20 years' total so that I can get all my zero rows to show up in the pivot table!)
Leslie Gehring
Leslie - see if this dashboard helps? 6318.20DEVOMonthlyReport.dash The pivot table has some the year to date comparison formulas.
Madeline, that has a lot of the same columns I'm looking for, but I'm trying to add a column for FY19 contribution total in addition to FY19 year-to-date. That way I can see where we are compared to where we were this time last year and where we are this year compared to the total we raised in all of last year. Does that make sense?
Yes - that does make sense. You could use the formula in that dashboard where I figure out the difference but remove the advanced date filters and achieve what you're looking for. My analytics is down right now so I can't double-check my work but something along the lines of (Contribution Total, CampaignFY19) - (Contribution Total, Campaign20) with no advanced filters.