Your are blending data and it totals not pick up correctly.
I've solved it but the real answer here is to join your data. Handling total with blending is quite complicated.
Please check the attached workbook.
I tried to create brand new worksheet and follow the exact steps that you mentioned. But sub-totals are not showing correctly. Please see attached workbook and see Sheet 3. Is there any specific trick you are doing to show the sub-totals correctly?
Following up on this.
If your problem is resolved, please mark the response as correct and helpful so that other folks with the same query can refer it.