Line chart showing values for previous 12 months

[#1]

Hi There, On the left side in my dashboard i have my Actual Trends and right hand side shows FY and Period.  I want the actual trend Line chart to show the values for previous 12 months, say in click on FY 2016, Period: 3,, i want actual trends to show values from 2015 03 to 2016 03..... Can anybody help me with the same please ? Thanks indeed.

[#2]

Hey Peter, This is my Calendar tab that shows :

//Temporarily coming from excel as PE Clone doesn't have latest periods

tblControlPeriods:

LOAD PeriodIndex,

     YearEndDate,

     PeriodStartDate,

     PeriodEndDate,

     Period,

     FY,

     Quarter,

     PeriodStatus,

     PeriodDescription,

     PeriodWIPMax,

     PeriodDRSMax,

     PeriodWIPClearMax,

     PeriodDRSClearMax,

     PeriodVATMax,

     [Date(CashStartDate)],

     [Date(CashEndDate)],

     FYPeriod,

     CalMonth,

     CalYear

FROM

[Excel Sources\Calendar_test.xls]

(biff, embedded labels, table is Sheet1$);