Find Feature

[#1]

I want to be able to use a find feature while in the straight table or pivot table, without losing the presentation.  In otherwords, I have a pivot table that is 100 rows long and I want to search for a specific name in a field so that it will show me that that name is on row 77.

Help??

[shree909]

HI,

Instead of search Ypu can make a list of dimensions as a drop down list in that u can search for particular value .

Goto the Presenetation tab of pivot table

pivot table--> properties--> presentation tab-->> Dimenison and expression   check mark the  Drop downlist for  the fields u want to filter,,

Thanks