Have you tried below logic:
Tried that but it's not working as it should be.
2 of 2 people found this helpful
Dont add year in the view and use
if year(([Order Date]))= year(TODAY()) then ([Sales])end
if year(([Order Date]))= year(TODAY())-1 then ([Sales])end
Drag month in view and add current and previous sales.
Oh wow! this is amazing. Thanks for the tip!