text in data area on pivot table "jmb" <jmbeauch[ at ]sympatico.ca> 28.09.2006 02:03:02 I want to generate an event calandar trigger by a database whit text in the data area. Pivot table is nice to display, sorting, filtering and calculate, but i need to put text field on the data area instead of number. The only other way that i see is to create a formula using match, vlokup, hlookup, with header and row Is there some other way to create a dynamic table with row and column headings, and text values? Thanks, JMB