Try using Lookup() instead of Previous_value(). I have recreated the issue using the Sample Superstore data. LOOKUP(SUM([Close]),-1) will work for you.
I created a calculated field called [Prev_Sales]
Put this in the view like the screenshot below. Right click on field name and select Compute Using Table (across).
Hope this helps.