Create a PivotTable based on the range A$7$:G$32.$ Place the PivotTable in cell I$17$ on the current worksheet. Place Payment Type in the Rows box and Amount in the Values box. Format the Amount with Accounting Number Format.