PivotTable new-row practice — expected result

All transactions are fictional.

Initial Sales!A1:C5: 4 order rows, 300 USD.
Rows to append!A2:C3: 2 order rows, 100 USD.
Combined Sales!A1:C7: 6 order rows, 400 USD.

Region  Before  After append
North      180           180
South       80           110
East        40            40
West         0            70
Total      300           400

If the PivotTable still shows 300 after Refresh, inspect Change Data Source.
A fixed Sales!A1:C5 source excludes rows 6 and 7. Use the complete list in
an Excel Table named SalesTable, repoint the PivotTable, and refresh again.