Pivot Table

[nabanco]

Hello,

This may be the wrong area, but thought I'd see.


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?

 

[ShaneDevenshire]

Hi,

Need more details - what do you mean return Underwrite now - do you want to
see the words. What does the data look like - is it all text or are there
numbers. If numbers what do you want to do with them - SUM, COUNT,
AVERAGE.... How should your pivot table be laid out - one column field for
eahc Underwrite field or ....

 

[nabanco]

Sheet 1 contains a column titled "Should I underwrite this loan?". There is
a logical function in the backgroud that answers either "Underwrite Now" or
"Don't Worry"

When I create a pivot table pulling data from the "Should I underwrite this
loan?" column, it pulls both "Underwrite Now" and "Don't Worry".

I am trying to get th epivot table to only consider the loans that are coded
as "underwrite now"

Does that help?

 

[ShaneDevenshire]

Create a pivot table with the Should I underwrite this loan field in both the
Data area and the Row area. Open the Row area filter and uncheck Don't Worry.