1 of 1 people found this helpful
You can, it's not a simple answer unfortunately.
If you had a view of sales by month, you could add this as a calculated field
And put that on the level of detail. You can then use that on a reference line per cell to give the value for the same month 1 year ago. If you wanted to filter the view, we have to be careful as a normal filter will mean that the values for a year ago are now not available for the lookup. We could hide the other data or use some other trickery to get the values.
Thanks for the help. It will do as a work-around. I wish I could dynamically change the reference line to be previous 2 months or probably last year or maybe average. I think I can add a parameter and do this.