combining pivot tables

[ssindemployee]

Hi, I have a new pivot table that I have imported external data. It is for remittances, so I have all of the transaction for a particular creditor. What I want to do now is insert the address into the top section of the document, so do I need to import more data within the workbook, turn that into a pivot table and then combine the two? Or is there an easier way?

 

[littleiitin]

If you have inserted new column for address in your worksheet, then create a freah Pivote table. if it already exists then drag and drop. in exiting one.