How to Calculate YTD vs. Prior YTD Based on a Selected Date

In this tip, I show you how to calculate year over year change based on a date selected with a parameter. The use case is to calculate YTD sales depending on the date selected and compare it to the prior YTD sales for the same period.

Download the workbook here - https://www.vizwiz.com/2022/04/ytd-vs-pytd.html

tableau tutorial tip year to date prior year to date year over year change percent change parameter calculated field variance difference boolean how to analysis comparison context formatting charts graphs data visualization data analysis