How to do Rolling Year

[#1]

Hi,

  I need to generate a growth graph by category of the (Rolling year) vs (Rolling Last Year), but i can´t put this dimensions in a graph because every Rolling Year i calculate separately,

the first dimension that i want to represent is the growth of the more actually 12 months between the 12 months preceding the current in the dimension

from the year more actually and to represent for a range of 5 years

Attached image to represent the type of graphic that i need

[its_anandrjs]

Hi,

See the attached sample file might be you have to use like this for rolling months

Rgds

Anand

[#3]

Hi Anand,

Thanks for your coment ... but i´m searching for anothe thing.... i´m searching for a graph the growth of the rolling year actual versus rolling year of the last year in a bar graph with the dimension "year"

i attach an example of the pivot table that i have now at this moment...

thanks !!