Calculating growth for month on month

[vijetas42]

Hi everyone,

I am having data of months for particular years suppose,I am selecting 2012 then it should show me growth by calculating for feb(feb-jan),for march(march-feb) and so on  and when it calculate for jan 2012 it should calculate jan-dec of year 2011

can anybody provide me solution for this?

[tresesco]

You can do it in the front end using above()/below() function. In the script, using previous()/peek() with proper sort order and group by. Try to create a sample qvw and share here if you need more help in details.

[vijetas42]

Here, I am attaching sample image where I want to display trend for month 1 also by taking jan 2012-dec 2011

[tresesco]

Script-way, like attached sample.