how to subtotal on this report

Question

My report currently show as following.   I'd like to sutotal/group by customer.  so each customer just shows up once with all data for the months filled.   Can I do it in SSRS?   How?  Thank you for your help

                  Jan    Feb     Mar    April   May                Oct Sept  Nov Dec

Customer1  2  

Customer1            3

Customer 1                                         5       

Ideally,

it should show as

                 Jan    Feb     Mar    April   May                Oct Sept  Nov Dec

Customer1  2        3                            5           

---

Thank You Warmest Fanny Pied

Answer 1

hi,

Try the following

Step 1: Insert matrix add customer name in row grouping and month name in Column grouping

---

Mark this as answer if this post helps you.