[URGENT] HELP FOR MATRIX TABLE

[dilshad_ahmed]

Hi Folks,

I have sales and closing supply data by week number. Below is the underlying data:

Week Number	Product	Closing Supply	Sales
W1	Maruti	100	125
W2	Maruti	50	356
W3	Maruti	150	458
W4	Maruti	260	621
W5	Maruti	300	20
W1	Innova	125	325
W2	Innova	15	125
W3	Innova	195	458
W4	Innova	365	478
W5	Innova	246	695
W1	XUV	154	555
W2	XUV	856	222
W3	XUV	654	351
W4	XUV	854	545
W5	XUV	215	215

I want to have a matrix table with week number as column for closing supply but do not want sales column for every week rather a single column. Below is the result that I want to achieve:

But in Power BI I am getting this result:

Is there any way to achieve the  desired result?

Link to PBIX file: https://drive.google.com/file/d/1Vm480X8HqFuzfByQoHMG_b6SpzmGi_Dp/view?usp=sharing

Thanks in Advance

[amitchandak]

@dilshad_ahmed , there is some problem in your excel(first Scrrenshot), that is complete sales data available in the file in the first column

I am getting the same value in excel

[dilshad_ahmed]

@amitchandak I want to achieve sum of sales in one column only, and not in every week.