Would need to create a 18 month look ahead calendar period. if the report is run in October 2016 it should have 18 months from oct and if it is run in nov it should be 18 months ahead from November. Please help . Thank you
X -axis has Start dates. The filter to roll 18 months should be on this date.
Hi Divya,
Find my approach as reference below and stored in attached workbook version 9.3
1. Rolling 18 month ahead:
IF datediff('month',[Order Date],[Current date])<= 0 and datediff('month',[Order Date],[Current date])>=-18
then [Order Date] END
Become a Viz Whiz on the Forums! Support the Community and master Tableau.