I would like to know, how to find the difference between odd years and even years like
I need difference b/w 2015 & 2017, b/w 2016 & 2018 of any measure like sales or profit.
how can we do it? what type of calculated field can we use?
Sum(if Year(Date Dimension) = P.Year then [Measure]) - SUM (If Datediff('year',Date Dimension, P.year) =2 then [Measure])
P.Year is a Parameter or you can choose a Max Date.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...