Weeks with amounts in columns

[Anonymous]

Hi,

I'm currently working on a dataset with an another layout that I'm used to.

Normaly I've got the weeks sorted in the rows, as below;

But for now, the weeks are spread over the columns, as below;

For example, how am I going to process the total sales of the Porsche Taycan? And how can I make a sum of the total sales?

Questions, questions, questions...

Cheers!

[Ashish_Mathur · Accepted solution]

Hi,

Select the first 2 columns, right click and click on "Unpivot Other Columns".  You will now see the Table as you see in image 1.

[v-cgao-msft · Accepted solution]

Hi @Anonymous ，

Transform data.

Select column [Brand] and column [Model] -> right click and click Unpivot Other Columns -> Close and apply.

Attach the PBIX file for reference. Hope it helps.

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Ashish_Mathur · Accepted solution]

Hi,

Select the first 2 columns, right click and click on "Unpivot Other Columns".  You will now see the Table as you see in image 1.

[truptis]

Hi @Anonymous ,

Try to Pivot your table. Once you Pivot it you will get the desired structure and then you can calculate Sales based upon Brand. 

@Anonymous if this helps you, then please hit the thumbs up. Thanks.