Thread: PivotTable help

Hello everyone,

I have a problem with a database I am preparing for my work. After hours of thinking about it, I have to admit I am blocked which explains I am requiring your help.

I have original data in a table, organized like that (in columns) :
Investor - Investor Type - Investor Location - Amount invested - Deal where amount was invested - Type of deal
I have built a pivot table with the row field being "Investor" and the column one being "Deal where invested". It gives me the amount invested by each investor in each deal, which is perfect.
However, I need to add for each investor its type and location, which seems impossible as I cannot insert any column in my pivot table.

I could not manage to extract my Pivot Table data so that I can simply add the columns in another sheet AND keeping automatic update of the Pivot Table when I update my original Data Table.
The most important aspect of all this is the automatization of updating (because I can''t update it manually, there are thousands of investors and dozens of deals, with new ones regularly being added...).

Is there any way to do this ? I hope I am clear enough...

Thanks in advance for your help

Romain