Forum Discussion
Pulling non-number data from a pivot table
Detlef_LewinDo you mean build a new pivot table using the first pivot table as a source? The fields you mention are already in the "rows" area. I'm not sure building a second pivot table will work either because I need to add data/columns for things that aren't in the original source data (and not calculated fields, either, but strings like dates). That's why I'm trying to pull the pivot table data into a regular table.
I'm not sure building a second pivot table will work either because I need to add data/columns for things that aren't in the original source data (and not calculated fields, either, but strings like dates).You didn't mention this in your first statement.
Please provide a sample file that explains the whole scope of what you are trying to achieve.
See new upload. There is now a sheet that has a regular table like the one I am trying to make. You'll see it pulls in some info with getpivotdata, but I had to copy over the text/string data by hand, and the last two columns are entered by hand as well.
What I'd like is for the text/string columns that are matched with the pivot table to be sourced from the pivot table in such a way that a) if that data (e.g. the contract expiration date) changes, it updates in the regular table too, and b) if NEW data is added to the pivot table (e.g. a new vendor, or a new contract under an existing vendor) it would add that to the regular table as well, just leaving the last two columns blank for me to input manually.
I know that b) is probably a stretch. I'd be thrilled just to solve a).
