In my project I need to find the difference or sum of two continue months. For the difference I used the formula as
ZN(SUM([Sales Forecast])) - LOOKUP(ZN(SUM([Sales Forecast])), -1)
And now the requirement for February month need to print the result as "((January - December )+( February-January))" ,
For march month is "((January - December )+( February-January)+(March-February)))" ,.... up to December.
Please any one help for solve these problem.
Not sure....but find my approach as reference below and stored in attached workbook version 9.3
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...