I am creating some period over period charts in VA. I am charting Sales (Difference from Previous Parallel Period) by month. The data ranges from 1/1/14-10/31/15. The Difference from Previous Parallel Period metrics are missing for 2014 because the dataset does not include 2013 data. This was expected.
I do not want the bar charts and crosstabs to show 2014 data as it is missing. Is there a way to control the output so the charts shows only 2015? Filtering on date does not work as the 2014 data is needed to calculate the 2015 (Difference from Previous Parallel Period). I don't believe you can filter on an aggregated measure either. I have attached a screen shot for reference.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.