Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table
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 .... -- Cheers, Shane Devenshire "nabanco" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table
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" wrote: 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 .... -- Cheers, Shane Devenshire "nabanco" wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table
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. -- Cheers, Shane Devenshire "nabanco" wrote: 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" wrote: 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 .... -- Cheers, Shane Devenshire "nabanco" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
Pivot table keeps dupping to another linked pivot table | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |