This is not correct. I need the difference between the week numbers within the farthest right column. I want the difference between the weeks of the calling dates. The date field means nothing nor do I need it in the calculation.
Using product x1 for example going down the table: I want to see week 9 minus week 10= -1; week 10 minus week 12= -2
1 of 1 people found this helpful
I am not sure about your actual expectation, hoping below is your requirement.
PFA the workbook as well developed in Tableau 10.2
Hi - I posted this on the other thread you have on this issue
I am on a different version but will walk you through the calculation
First Is this your table
The date difference calculation is DATEDIFF('week',min([Calling Dates]),lookup(min([Calling Dates]),-1))
where you do the table calculation DOWN
Let me know if this helps