Hello,

We have the below report that breaks out product categories by a defined date range. We want to add another column with the previous year total, relative to the report date.

Here are the current report settings, with the previous yr column i added.

However, the report now has all these blank monthly rows. If there is a way to remove all the previous yr monthly columns, i think the report will work. The only column i would like to add is the one circled in red below (Previous Year Sales).

Thanks!