You can use similar calculation and adjust the starting and ending month for the average calculation
[Amount 12 (Prev Period)]
WINDOW_AVG(SUM([Amount]), -12, -1)
This mean start by the last month and move back 12 month, also for year
[Amount 12 (Last Year)]
WINDOW_AVG(SUM([Amount]), -23, -12)
the important thing to have enough data in you data set (month).
thanks for the reply, however If you open up the attached file you can see that i kinda already do that in R12_Amount calculation.
My problem is to plug the last month R12 number into the circle in the Screenshot below.
This is my calculation there that doesn work
DATETRUNC([Compare by],MAX([Date])) = DATETRUNC([Compare by],max([Pick a Date]))
DATETRUNC('month',MAX([Date])) = DATETRUNC('month',max([Pick a Date]))
1 of 1 people found this helpful
Ok, you are trying to use table calculation without include the calc dimension (Month) ... you can do the following:
1- drag the date into detail mark as follow:
2- Change your table calculation to be as follow
3- Add your table calculation to size mark to get the last month calculated value as follow:
If you found this the useful, please mark it as the correct answer or helpful post
This is great ! I can't thank you enough
u r welcome