How to compare monthly sales data over the past 3 years for a given month?

I thought your original request was July this year, July last Year July the year before, now it is Jan, Feb through to December as lines. with the columns yearly - this changes things. This is not possible from memory due to the line construction. To achieve this you would need to either write a modified view or report.