Displaying previous 12 Period details on bar chart based up on current selection

[#1]

Hi All,

         I have a scenario where i want to display the previous period details in my barchart based up on my selection

Going in Detail

let us suppose i have 4 years of data

Ex:

Year        Period       Revenue

2012           1               5456

2013           2               4543

2014           3                 454121

2015           4                 5454

                   5                   4564

                   6                 153

                   7                 456463

                   8                 4542123

                   9                     8745

                  10                  78744

                   11               45466

                    12              333546

Each Year Got 12 periods and their respective revenues.

my requirement is when i select year 2014 and period=6 then the bar chart has to display revenue of 5,4,3,2,1,12,11,10,9,8,7,6

periods

where 5,4,3,2,1 belongs to 2014

and 12,11,10,9,8,7,6 belongs to previous year i.e; in this example 2013

Thanks & Regards

Abhilash