Forum Discussion

vikash1984's avatar
vikash1984
Former Employee
Jul 27, 2022
Solved

Merge and Sum unique values linked to repetitive ID

Hello, I need help with the following task in hand. Need to sum amount paid through same cost center and show the total amount in 1 row instead of multiple rows by EE ID. Sample Data EE ID Cos...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jul 27, 2022

    vikash1984 click inside the pivot table. On he Design ribbon, choose Report Layout. Select Tabular and then Repeat All Item Labels. Then, under Subtotals, Do Not Show Subtotals.

    Last thing I did was to toggle off the +/- buttons in the PivotTable Analyze ribbon. Oh, and I removed the Grand Total as well.

     

  • vikash1984's avatar
    vikash1984
    Former Employee
    Jul 27, 2022

    Riny_van_Eekelen How did you move cost center into separate column? I created pivot table, but EE ID and Cost center are appearing in same column. I am attaching sheet for your reference. 

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jul 27, 2022

      vikash1984 click inside the pivot table. On he Design ribbon, choose Report Layout. Select Tabular and then Repeat All Item Labels. Then, under Subtotals, Do Not Show Subtotals.

      Last thing I did was to toggle off the +/- buttons in the PivotTable Analyze ribbon. Oh, and I removed the Grand Total as well.

       

      • vikash1984's avatar
        vikash1984
        Former Employee
        Jul 27, 2022
        done, working for me now. Thanks so much for the help. 🙂

Resources