Matrix sums values within each row 'category' - I only want the sum total for each row 'category'

[elsteshepardo]

Hi,

I have a simple table:

I want to show this as a matrix - showing each Deliverable & Resource, like this:

But as you can see, for each Deliverable it's calculating the sum of effort 'wrong' The table shows the Business Analyst role being 0.5 effort for the Business Case Deliverable - the matrix is multiplying everything by 4.

I can change the value to MAX rather than SUM, but then the sub-totals don't work. What am I doing wrong?

Thanks

[v-yanjiang-msft]

Hi @elsteshepardo ,

By my test, if your data source is just the same as you provided, it will get the below result:

You sort the data source table with "ower" column, I doubt if there're still other rows for the group for example "Business Case-Business Analyst" with other owers haven't shown in your data source. If so, it will aotumatically summarize in matrix as they're all in the group "Business Case-Business Analyst".

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.