I'm trying to build a report in Analysis for office to compare two years side by side. For example I would like to see 2019 & 2018 on the same report. I would like to be able to select 2019 and have a minus one formula for the column next to 2019 that will define 2018 automatically.
Basically select a year and next to it have a column that will show year before.
Your Inputs are Highly Appreciated.