Dear Community
I am need some guidance on the below formula:
I am using this to create a rolling MAT Value by Month and it works fine. The formula is:
=sum(if(Year2Date(PERIOD,0,if(MONTH(LatestDate)>11,1,MONTH(LatestDate)+1),LatestDate),$(vMeasure)))
My output is as follows:
| MANUFACTURER | MonthYr | Aug 2018 | Sep 2018 | Oct 2018 | Nov 2018 | Dec 2018 | Jan 2019 | Feb 2019 | Mar 2019 | Apr 2019 | May 2019 | Jun 2019 | Jul 2019 |
| Manufac 1 | | 907,700,199 | 916,079,988 | 925,411,401 | 934,516,386 | 942,949,693 | 950,110,401 | 955,958,829 | 961,816,170 | 964,160,990 | 968,366,379 | 970,790,467 | 972,803,259 |
I need to find a way to calculate the % growth between Jul 2019 vs Jul 2018
Please help
