DYNAMIC LAST EIGHT FINANCIAL MONTH

[#1]

Hai,

how to i get last dynamic last 8 months in fin calendar

ex: this is dec if i select dec-2013 then show below out put

may

jun

jul

aug

sep

oct

nov

dec

same way if i selet full year ex 2012 i have all  months so out put wil be

aug

sep

oct

nov

dec

jan

feb

mar

pls give me any idea its rearly help for me

[#2]

i am getting data but wn i select year values showin fine but wn i select month the order is not showing fine

can i send my logic ans variables

[er_mohit]

send me your logic ans variable

you shuld write dual for month also

in above script 

DUAL(Year(DATE) & Ceil(dual(MONTH(DATE)-4),Year(DATE) & Ceil(MONTH(DATE)-4))) AS EGHITYR;

hope it helps..

if it might be either helpful or correct answer to you then mark it as helpful or correct answer. because doing this it can be helpful for lot of developers.