How to create multiple pivot column

[aanmi]

Hi

I would like to create pivot table which able to pivot 2 different columns (Pieces and Unit Price)  as below.

A = original data in database

B = The pivot table I want to visualize

I already try to use pivot column option but the result is not what I want.

Please advise

[BhaveshPatel · Accepted solution]

You should use Matrix Visual.

[aanmi]

Thank you.

It's working