Skip to Content
Oct 21, 2020 at 02:54 AM

Filtering in Analysis for Office 2.8 SP4


Hi All,

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.