Adjust sales data that comes in columns

[Anonymous]

Hello!

My sales data comes in a weird way... it sums each month by a column. Which makes recreating a pivot by a Matrix difficult. I'm not sure if there's specific measures or new coloumns i'd need to recreate -- any help or direction is appreciated. 

1) sales data example: 1-12 is Month, and the Qty attatched to that fiscal year, material, plant. 

2) goal view: i'd want to recreate this Pivot table via Matrix. 

[amitchandak · Accepted solution]

@Anonymous , If the first screenshot is a raw data format, Then remove TTL and ytd and unpivot all month columns and then you can do easy analysis

https://radacad.com/pivot-and-unpivot-with-power-bi