Hi All,
I am having report where I am inserting 2 row groups. skeleton is like below.
Manager,Rep,product, Sales
I am inserting group on Manager as parent and Rep as a chield group.
Now I want to display total sales as below fromat on SSRS. I mean whenever group value changes, then i want to display group sum like below.
Manager REP Product Sale
Abhas 1 A 100
1 b 200
total sales by 1 = 300
2 A 50
2 M 50
Total sales by 2 = 100
Total Sales by Manager Abhas = 400
Tom 3 A 100
total sales by 3 = 100
Total sales by Manager TOM = 100
Grand Total = 5000
Appreciate you help.
Thanks
Abhas,