Hello,

Do you have a solution to tbe below?

I am trying to create a pivot table that returns only "Underwrite Now" from
another sheet but does not return "Don't Worry".

in other words, in sheet 1 the columns all read either "Underwrite Now" or
"Don't Worry". I am trying to exclude the "Don't Worry" findings from the
pivot table.

Is that possible?

Thank you

Add that field to the page area, and select Underwrite Now from the
dropdown list.

nabanco wrote:
Hello,

Do you have a solution to tbe below?

I am trying to create a pivot table that returns only "Underwrite Now" from
another sheet but does not return "Don't Worry".

in other words, in sheet 1 the columns all read either "Underwrite Now" or
"Don't Worry". I am trying to exclude the "Don't Worry" findings from the
pivot table.

Is that possible?

Thank you


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html