how to add cost values of same products in same column

[Muavia]

Rep office	status	cost
A2	processing	1902
A2	processing	8721
A9	overdue	1921
A2	processed	2001
A2	processed	2213
A9	processed	22113
A5	processing	2213
A2	processing	4343
A5	Overdue	2321
A2	closed	1123
A5	closed	9382
A5	closed	8382
A5	processing	912

i have a data like this and i want to calculate same name values from status column and than add the cost of that all values for example rep office of A2 have  a processing status of 3 times and i need to add that all3 processing cost  1902+8721+4343 

than A2 have a status of processed 2 times taht cost 2001+2213=4214and my end result or graph should be like this

Rep office                  closed     overdue      processed      processing

A2                              1123          -                  4214                      14966

A5

A9

..

which query or expression i need to enter thanks

[v-yulgu-msft · Accepted solution]

Hi @Muavia,

You need a Matrix. Place [Rep office] in "Rows", [status] in "Columns" and [cost] in "Values".

Best regards,

Yuliana Gu

[HotChilli]

Use Power Query editor.

select the 'status' column.

Click ''Pivot Column',  select 'cost' in the dropdown when it appears. Click ok