Matrix Table Display Issue

[Anonymous]

I am having trouble making a Matrix table display the way I would like.  Below is an example of my issue.  On the left is an image of how the Matrix table is displaying the results.  Note that the KAM group in broken into two sections based on the team.  I would like the results to display like the right example which National and Exc. National fall under the same KAM group.  This would allow for a total line for all of KAM versus two different KAM totals.  Below this image is a screen shot of the data table that I am using to set this up.  Is there a better table structure that would allow the right image version to work?

[Anonymous]

Hi @Anonymous,

I think the issue may related to records, please double check if these column contains whitespace.

You can use replacevalue function to remove whitespace in power query:

Remove=Table.ReplaceValue(#"Changed Type"," ","",Replacer.ReplaceText,{"ColumnName"})

Regards,

Xiaoxin Sheng

[GilbertQ]

Hi @Anonymous

If you use the Matrix and put in the Group, Team and Demand Group under the Rows it will group as you want it to in your image on the right hand side.

[Anonymous]

Alas they are all under rows...any other possibilities?

[MFelix]

Hi @Anonymous,

In your image there is a Team Order # Is this the same for all of the values below? If there sre different Team Order # for each KAM you won't get the display as you want bit one KAM per row instead of a.group for KAM and then two rows.

Regards,
MFelix