Hi,
I have a small requirement, is that based on the month selected need to get the rolling 12 months and 24 months back trend .
Say for eg:
Selected month was october and year was 2015
so the trend graoh should show the actual from october 2015 and back till November 2014
Similarly based on the filter month and year the trend should display
data is as given below:
| FiscalMonth | MonthName | FYMonth | FiscalYear | Actual |
| 1 | October | Oct-14 | 2014 | 10 |
| 2 | November | Nov-14 | 2014 | 9 |
| 3 | December | Dec-14 | 2014 | 8 |
| 4 | January | Jan-14 | 2014 | 7 |
| 5 | February | Feb-14 | 2014 | 6 |
| 6 | March | Mar-14 | 2014 | 5 |
| 7 | April | Apr-14 | 2014 | 5 |
| 8 | May | May-14 | 2014 | 6 |
| 9 | June | Jun-14 | 2014 | 7 |
| 10 | July | Jul-14 | 2014 | 8 |
| 11 | August | Aug-14 | 2014 | 9 |
| 12 | September | Sep-14 | 2014 | 10 |
| 1 | October | Oct-15 | 2015 | 1 |
| 2 | November | Nov-15 | 2015 | 2 |
| 3 | December | Dec-15 | 2015 | 3 |
| 4 | January | Jan-15 | 2015 | 4 |
| 5 | February | Feb-15 | 2015 | 5 |
| 6 | March | Mar-15 | 2015 | 6 |
| 7 | April | Apr-15 | 2015 | 6 |
| 8 | May | May-15 | 2015 | 5 |
| 9 | June | Jun-15 | 2015 | 4 |
| 10 | July | Jul-15 | 2015 | 3 |
| 11 | August | Aug-15 | 2015 | 2 |
| 12 | September | Sep-15 | 2015 | 1 |
Applied dimension: FYMonth
Expression:
Sum
({<FiscalYear=,Quarter=,MonthName=,Date={">=$(=MonthStart(Max(DateFull),-11))<=$(=Date(Max(DateFull)))"},>}Actual)
But the required rolling moths data was not coming. can please help me out to get the same.
