Calculation Group Within a Matrix & Hierarchy Totals

[lg1551]

I have a calculation group which is pulling values into a matrix table.

I have a hierarchy of Region and Location. For any Regions that do not have Locations I am getting two lines, 1 for Total and one for the values.

I am getting this result:

Region	Location	Segment 1	Segment 2	Segment 3	Segment 4
Europe		1	1	1	1
	Total	1	1	1	1
Asia		1	1	1	1
	Total	1	1	1	1
North America	Location1	1	1	1	1
	Location2	1	1	1	1
	Location3	1	1	1	1
	Total	1	1	1	1
South America		1	1	1	1
	Total	1	1	1	1

And I want this result:

Region	Location	Segment 1	Segment 2	Segment 3	Segment 4
Europe		1	1	1	1
Asia		1	1	1	1
North America		1	1	1	1
	Location1	1	1	1	1
	Location2	1	1	1	1
	Location3	1	1	1	1
South America		1	1	1	1

How can I incorproate "InScope" or other functionality to provide the totals on the correct line items and not create the additional rows?

[v-yiruan-msft · Accepted solution]

Hi @lg1551 ,

Please select the related matrix visual and navigate to Format pane to toggle off the option "Row subtotals"， Later check if you can get the expected result.

If the above one can't help you, please provide some raw data refer in the matrix and the Fields settings of the matrix. Thank you.

Best Regards