Hello. I'm hoping someone can help me. I have a bit of a dilemma.
I have a pivot table like the one below, with the pivot table filtered by calendar year at the top. See sample book as well.
Count of Applications
Is it possible to create a calculated field that changes when the report filter for calendar year changes?
For example, I'd like the pivot table to show a column for one calculated field when I select the year 2015 in the filter, and a different calculated field when I select 2016.
Is it possible to do this??