Total SUM at end of Column in MATRIX Table

[damit23183]

Hi, 

I am working on MATRIX table where i would like to see TOTAL SUM at end of each column.

Here is what i have where you can There are total 3 SUB COLUMNS under PARENT COLUMN. For Example Under AGE There are other 3 Columns C,  A ,DC

As you can see RED HIGHLIGHTED, where i want to total SUM of each column. For Example; first Column C has 34 where i would like to see 55.

Also, here are settings I have applied on SUB TOTAL Formatting part;

[v-eachen-msft]

Hi @damit23183 ,

You could use ISINSCOPE() to custom your total rows.

Here is my test result. There are some average values in "Values" field and show sum values in total row.

Here is my test file for your reference.

[damit23183]

Hi,

Thank you for your response.

This is awesome it worked perfectly fine.

Also, i have another requirement too which i am going to put as new request.

Thanks

[edhans]

It is how the data is in the underlying table. The totals on tables and matrix visuals do not add the number above them, rather they recompute the value based on the filters and your measure. This article has a good overview of understanding the issue and how to solve it.