Group Totals Issue

I’m far from an SSRS expert so I thought I would reach out to the experts for some help. Hopefully it will help others in the process as well. I was not able to paste my screen shots on here for some reason so I have to use tables.

I’m working on an SSRS report that has several groupings. The problem I haven’t been able to resolve is displaying the totals correctly for the parent group in my Tablix. The result I am going for is in the Table 1.

Table 1 Result Needed

 Table 2 shows what my report is currently displaying. As you can see it’s displaying the Order Type grouping total incorrectly.  It’s not giving me the grand total for each Order Type. Line is my parent group.

Table 2 Current Report Result

There must be away to get the result I want I just haven’t been able to figure it out. Any suggestions would be greatly appreciated.

One thing you might want to try is instead of using the Add Total, right-click your details group, and select Add Group, then select Adjacent After. For your grouping, select Order Type. That should allow you to show the Sum of each Order Type in a Totals line at the bottom. Let me know if that works for you.

It's closer now. It's causes the Inventory and Released Order Numbers to double. Those are already sumed prior to the totals because we don't need them by Order Type.

Have you tried creating a parent group based on Released Orders with the child group being Order Type?