Overlapping time periods

Hi

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.

Chris

Attachments

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