Ungrouping rows

[saranee]

Hi everyone,

Need a little help on this 

When we are presenting data(say for e.g:Name,Marks) in matrix,it is getting grouped by Name like:

originally coming

But we need Name in each row like:

required

 Please can you let me know how to ungroup Name.

Any help is much appreciated.

Thanks,

Saranee

[Anonymous]

Try using a "Table" visual, instead of a "Matrix" visual, and ensure any subsequent columns are set to "Don't Summarize".

Although, based on your sample screenshots, it's a little unclear as to what your data actually looks like, and what you're actually trying to show.

[saranee]

Thanks for your reply.But we can not use table visualization in this case.Name column is unsummarized only.

Please let me know if we can implement this thing keeping matrix as visualization.

Thanks,

Saranee

[v-yuezhe-msft]

@saranee,

How do you store data in your original table? If your original table looks like below, you can only use table visual to get expected result. In Matrix visual, the marks are automatically summarized for each name.



Regards,
Lydia