text in data area on pivot table

J

jmb

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
 
Top