Scenario to display sales data in between years using set analysis.
Recently I attended an interview. Below is one of the questions asked. Could any one please help me with the answer.
Suppose we have sales data for years from 2001 to 2015. If I select year 2015, the chart should display sales data for years 2010 to 2015. Similarly, If I select year 2010, the chart should display sales data for years 2005 to 2010.