how to pivot the data in a matrix

[vickyArce]

I have a matrix like this, how to pivot the matrix to make it look like the new table?Original table

[v-yulgu-msft · Accepted solution]

Hi @vickyArce ,

In above Matrix, [SumSortant], [SumCountItem], [SumEntrant], etc are measures, right? If so, Vvelarde's should work. Please see below example. Please check whether you missed any step.

If not, please share your sample data in source table.

Best regards,

Yuliana Gu

[Vvelarde]

@vickyArce 

Hi, go to Format--Values--Show on Rows

Move the "Fours" to Columns in the matrix

Regards

Victor

[Ferfer]

Works well and easy solution thanks

[vickyArce]

Thank you for your reply, but that does not work, I already tried that.

regards,

Vicky