if i select the nov16 in filter and i need the calculation for Apr16 to NOV16
Find my approach as reference below and stored in attached workbook version 9.3
Display??:DATEDIFF('month',[Date],[Date Parameter])<=5 and DATEDIFF('month',[Date],[Date Parameter])>=0
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...