Column Calculation in pivot table
I just build a pivot table with
Year as column & dynamic filters ( so that column is dynamic )
Month as row
Amount as values
When I select year 2020 and 2018, the pivot table displays the values as expected.
The question is, how do I add column calculation to show the variance between the two years selected ( assuming we made that only 2 selections can be made )