is there a way to add text to the Data Field in a pivot table?

[adamsturtevant]

Hi everybody...

So i have a raw data dump that I need to put in a spacific reporting fashion. Excel pivot tables seems to almost do the trick. The problem is the information that I need to drop in the "data" field is text (peoples usernames) and when I drop it in I get numbers instead of names, and when I drill down on the number then I get the exact format I need but only for that line... Any ideas? I am using Excel 2000

If pivot tables will not work does anybody know of another was to get raw data in a mapping type of spreadsheet>?

 

[johnwc]

You may be able to get part of the way there using the GETPIVOTDATA function. Since pivot tables generally cannot be manipulated, you can create your own report that displays pivot table data. Simply type '=' in the cell in your custom report, click on the target data cell in the pivot table, and press Enter. You could use this in combination with a CONCATENATE function to get what you show in G8. The benefit to doing it this way is that as the source data in your pivot table changes, your custom report will change as well so you don't have to rebuild it every time. This may require some creative design of the source data/pivot table, but seems doable. May keep you entertained while you wait for someone's clever macro anyway :D