In R, type the call that totals amount by province — the same four rows as the pivot.

Answer

aggregate(amount ~ prov, data = orders, FUN = sum)

Values ~ Rows, the data frame, the function. AB 2300, BC 1360, ON 1995, QC 485 — alphabetical, like the pivot.