-
1. Re: Compare month with average of previous year
1 of 1 people found this helpfulCreate a date parameter
1. Sales=
sum(if year([Order Date])= year([date parameter])
AND month([Order Date])=month([date parameter])
then [Sales]
end)
2. Avg Sales=
sum(if year([Order Date])= year([Date parameter])-1
then [Sales]
end)/12
-
2. Re: Compare month with average of previous year
Thanks, I was really stuck , and your solution seems so intuitive !
Have a good day!
