Forum Discussion
Resolver IICalculation Group Within a Matrix & Hierarchy Totals
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?
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
1 Reply
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