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.
As per my below screenshot I have used below formula to E2 cell to extract unique values.
=UNIQUE(A2:B12)And below formula to G2 cell to sum.
=SUMIFS($C$2:$C$12,$A$2:$A$12,E2,$B$2:$B$12,F2)