We are trying to implement YoY growth.
We are giving the user the ability to select the period and aggregation level (monthly, quarterly, yearly) using parameter.
Depending on the start date and end date and the aggregation level the chart should display the yoy growth.
If the user selects period from 1-Jan-2017 to 31-May-2017 and the aggregation level is set at Month, the chart displays all the dates from 2016 as well and values from 1-Jan-2017 onwards.
Is there a way I can show only 2017 data?
Thanks & Regards,
Mind sharing a packaged workbook so we can take a closer look?