How would I get the value of the same period last year without using parameters? Ultimately I'd like the table in Tableau to look something like the screenshot below. I've attached a sample workbook with the relevant data. Just to reiterate, I'm wanting to show the value for the same period last year for not only 2021 but for all the months in the data.
3 answers
Hello @Max Lee ,
Use this calculation. Lookup(sum([value]),-1) . Set it at the level of year. See attached.
If you want to add more dimensions in, the partitioning gets more complex.
Is that what you are looking for?
@Robert Breen
