Forum Discussion

vt_excel's avatar
vt_excel
Copper Contributor
Jan 15, 2023

Applying pivot and combining few of its columns

1. Have a dataset below, when I apply pivot I want that last three columsn get combined as in final result, is it possible?   Customer Name Manufacturer Item Order Date Bill Date Amount ...
excel
  • vt_excel's avatar
    vt_excel
    Copper Contributor
    Jan 15, 2023

    Riny_van_Eekelen 

    Thanks for inputs.

     

    1. When i try to put filter on pivot table, and arrange in ascending order for either name, manufacturer or item, consolidated columns goes away

     

    before filter

     

     

     

     

     

    After filter 

     

     

    2. ALso whats the formula applied to combined item?

     

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jan 15, 2023

      vt_excel That doesn't happen for me.

       

      In Power Pivot, I added a calculated column that combines the three relevant columns and then I created a DAX measure that allows you to include a text in the value field of the pivot table. Press this button

      on the Power Pivot ribbon to get into Power Pivot / Data Model.

       

      Now, if you are unfamiliar with Power Pivot and DAX, it's going to be challenge to just "hop on" and expect that everything will be clear at once.

      • vt_excel's avatar
        vt_excel
        Copper Contributor
        Jan 21, 2023

        Riny_van_Eekelen Hi

        I tried similiar thing, but I got error this, can you please advise.

        Attached is excel where I am working