This is driving me a bit bonkers. It seems like it should be easy but SSRS has me stumped.

I want to create a report of our customers displaying the monthly sales totals and display the Quarter totals at the end of  every third month, e.g.

Customer       Jan Feb Mar Quarter1 Apr May Jun Quarter2 Jul Aug...

I'm new to SSRS and I've created the report with the Quarter totals and the far right end, but I can place my finger on how to do it every three months.

Searching the web has not really helped me produce a solution. If you can give me insights, I'd appreciate it.

Hi Joel, 

According to your description, you want to add a column which calculates the quarter total sales, right? 

In your scenario, we can add a column group to the column with the following expression, please refer to the following steps: 

1. Right-click the column group and add a parent column group. Then group on this expression: =Ceiling(rownumber(nothing)/3)
2. Right-click the detail field, and then click Add Total to the column.

The result is like below: 

If you have any other question, please feel free to ask. 

Regards,
Shrek Li