It seems there would be any column between group and measure
just remove that field automatically it will sum it up
or could you please provide your Fields layout how you place in the worksheet
Hope this helps kindly mark this answer as correct/helpful so that it will help others
Please find enclosed sample workbook created based on my understanding of your requirement. Is this what you are looking at? Else, please share a sample packaged workbook so that someone will help you.
Thanks both of you! I remove a field from rows and it works!