I'm trying to recreate an excel report as a pivot table. It's for Development and shows their progress toward goal for campaigns this year vs. the progress for those same campaigns on this date last year. One column is for this year and the other is the previous year. I don't need a date filter on this year, but I do need to filter contribution sum by date to get the "last year" number.
I figured out the formula for the date filter, I just don't know how to apply it to the single column and not the entire widget.
I think this would work for you:
You would filter each formula by the Contribution Year you want, then duplicate the Value and re-filter for the next year. The whole widget would be filtered for the specific campaigns.
Perfect. I just had the syntax backwards. Thank you!