Feb 06 2019 08:24 AM
Feb 06 2019 08:24 AM
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.
Calendar Year | (All) |
Count of Applications | Region |
Rationale | North |
Blue | 3 |
Green | 1 |
Red | 5 |
Grand Total | 9 |
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??