Display previous Rolling 12 months on dashboard based on month drop down selection

Hi team
I need to display previous rolling 12 months on dashboard based on month drop down selection

Say for example - I have SQL

Select a11.period period ,
Unique id ,
a11.customer name ,
a11.customer status ,
a11.product,
a12.cust address
from
Customer a11
Left outer join
Status a12 on ( a11.unique id = a12.unique id )

Period is the month

Let me know the logic how we can implement this .

Thanks
Basavaraj

Basavaraj - have you seen this article: How to manipulate time filter using parameters

It’s a good example of how to control the filtering of visuals based on dates – to see 2 weeks back or 12 months back based on user selection.

Thanks
Shaun