Forum Discussion
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...
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 A pivot table would do that for you. See attached.
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.