 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2007Pivot 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? 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 ....  SignatureCheers, Shane Devenshire > Hello, > [quoted text clipped - 10 lines] > > Is that possible? 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? > Hi, > [quoted text clipped - 18 lines] > > > > Is that possible? 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. SignatureCheers, Shane Devenshire > 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 [quoted text clipped - 30 lines] > > > > > > Is that possible? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.