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