If you can manipulate the source data? Go to source data> Insert new column> Name new Column> click pivotTable>update source data>Done.