MrExcel Publishing
Your One Stop for Excel Tips & Solutions

pivot table


Posted by Lukas Weder on December 07, 2001 11:42 AM

is there a way to display text in the data-field of a pivot table?

thanx

Lukas


Posted by Mark W. on December 07, 2001 11:52 AM

Please elaborate...

Posted by Lukas Weder on December 07, 2001 12:03 PM

Re: Please elaborate...

sorry... ;-)

I have two columns in my excel sheet... first one is the date, the second one a commentary... I wanna create a commentarydatabase... The date should be the page field and the commentary in the data field... the pivot table should show me all the different commentaries for a specific date...

thanx!

Posted by Mark W. on December 07, 2001 12:06 PM

Re: Please elaborate...

Why don't you just use an AutoFilter?