Totaling for Previous Years with Current Year as an expression

[tim_at_ford]

To all

Currently I trying to resolve a problem with current and previous year totals.

I have a sales for a 2020 and then in following columns I want to be able to total up the previous so I can apply those values to "delta".

The issue I am having in using the sum function and year-1 is it's creating another row for the previous year (see attached)

What I want in the row is current year, sales and then previous years sales.

What I am getting is current year, sales and the an entirely new row of previous year and sales.

So how do I do this??

[Or]

Is "Current year" the same thing as "Year" in the set analysis? If not - how are you arriving at "Current year"? It doesn't seem like "Current Year" should have a possible value of 2019 in this context, as that's not the "Current Year" - 2020 is.

You could, for example, use a synthetic dimension here, such as:

=ValueList('$(=Max(Year))')

[tim_at_ford]

What it turned out to be was we were not using "back" and "forward".   That was new to our team.