Forum Discussion

fra93's avatar
fra93
Copper Contributor
May 18, 2020

TWO COLUMNS IN PIVOT TABLE

Hi, I hope you can help me.

 

Is there a way to create a pivot table with two same columns side by side? This is an example.

 

I have the product ID in the rows, then in the first column (column 1), I have the Months (Jan, Feb...). In the value field, I have the Stocks (pieces). In the other column (column 2), I would like to have Months as well while in the value field, I would like to have Sales (€).

 

For me it's important to have the same Product ID with two different values (Stocks and Sales).

 

Thanks

excel

3 Replies

    • fra93's avatar
      fra93
      Copper Contributor
      May 18, 2020

      I have all my files in my model of Power Pivot. I know formulas to add two pivot tables together but I would like to find a smarter way.

       

      I will attach what I would like to obtain.

       

      Thanks

      • bhushan_z's avatar
        bhushan_z
        Iron Contributor
        May 18, 2020

        fra93 your data is not ideal for Pivot Table.

        You can refer to these videos for guidance:

        https://www.youtube.com/watch?v=9NUjHBNWe9M

         

        Note: I have not prepared this video.

Resources