Overlapping time periods


Is there a way to show two different time periods on one graph. I.e. I want to show annual sales using a fiscal year offset of -6 (July year start), but also be able to show the total sales over the last twelve months at my latest period (December 2017). 

Attached is my source data (I've simplified this for the example) with the values and an example chart of what I would like to show, and a screenshot of my spotfire analysis as it is coming out.

Thanks in advance for your help.



Image icon annual_and_monthly_sales.png78.19 KB
File ltm_example_data.xlsx16.74 KB