• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Seperate Field Column Totals in Pivot Table

    Hi, I am trying to have one column total as 'count' and the other 3 columns total as 'sum' - I can only get them ALL to do one or the other. Is there a way to make BOTH 'sum' and 'count' appear in my pivot table? Excel 2010 Please and Thanks!
  2. A

    Check boxes in Excel 2003

    Hi! How do I create 'check boxes' in Excel 2003?
  3. A

    conditional formatting

    NEVERMIND!!! I FIGURED IT OUT!! YAY!!! THANKS EVERYONE!
  4. A

    conditional formatting

    THAT WORKED PERFECTLY!! THANK YOU! Now is there Conditional formatting for an AND statement such as =L2-J2>7 (red) AND L2-J2="BLANK" So that if the cell is blank it will remain blank rather than be red?
  5. A

    conditional formatting

    Thank you. that would work great except that my dates are not based off of the current week. so the =($L$2-TODAY)formulas do not work. For instance, cell J2 is the date 8/29/2011, and cell L2 is the date 9/2/2011. I need cell L2 to turn red since the time between the two dates is greater than...
  6. A

    conditional formatting

    Hello! I have raw data that needs conditional formatting for dates. I have an column of dates that represents the day that each appraisal was ordered on. And I have another column of dates that represent the day that each appraisal was received on. I need to set up conditional formatting...
  7. A

    Subtracting Subtotals with in a Pivot Table

    okay, I figured out the GETPIVOTDATA function yesterday..and it worked perfectly :) however, that function only worked for the GRAND TOTALS...I need SUBTOTALS.
  8. A

    Subtracting Subtotals with in a Pivot Table

    Hi! And thank you for your time! I need to figure out a way to subtract the SUBtotals column from a different SUBtotals column. For example: If my first column subtotals 20, and my second column subtotals 17, I need the difference in the totals to reflect in my fist column. 20-17=3 (so my...
  9. A

    subtotal formula for pivot table

    thanks I'll give it a shot :)
  10. A

    subtotal formula for pivot table

    I have used this formula to total the difference of my Count of Opened column and my Count of Credit Pulled column =GETPIVOTDATA("Count of Opened",Sheet2!$C$34)-GETPIVOTDATA("Count of Credit Pulled",Sheet2!$D$34) this formula works great. but it only totals the GRAND TOTAL in the pivot...
  11. A

    Change a Pivot Table Formula within the Totals Column

    FRED- THANKS!! That worked when I did it on the raw data sheet! However, it takes the total of all..it there a way to do it in sub totals?
  12. A

    Change a Pivot Table Formula within the Totals Column

    Fred- It will not allow me to change the formula within the pivot table..am I supposed to try the formula you suggested in the raw data section?
  13. A

    Change a Pivot Table Formula within the Totals Column

    Regarding my last comment: I tried Luke M's suggestion.
  14. A

    Change a Pivot Table Formula within the Totals Column

    I have tried this. I can't seem to get it to work...It always says #N/A
  15. A

    Change a Pivot Table Formula within the Totals Column

    HI! I need to figure out a way to subtract the totals column from a different totals column. For example: If my first column totals 10, and my second column totals 17, I need the difference in the totals to reflect in my fist column. 10-17=7 (so my first column is showing the difference within...
  16. A

    Running In Total in a Pivot Table

    Thanks :)
  17. A

    Running In Total in a Pivot Table

    Thanks! I think my raw data is fine (maybe not..idk) but my pivot table gives me every total I need. My boss is just picky and needs an cumlitive total that is based off of the totals that are already provided w/in the pivot table--is it possible to have to seperate rows w/the original totals...
  18. A

    Running In Total in a Pivot Table

    It unfortunately has one column for all of the different stages titled 'Loan Status' -- I have the pivot table made (maybe incorrectly to show the data I need?) -In my ROW column I have each Branch and each Loan Officer..so my LO's are sorted by Branch -In the DATA section I have: Count of...
  19. A

    Running In Total in a Pivot Table

    okay, I'm sorry I'm so needy... I just sent you a sample of the data I actually have on the spreadsheet. I actually have 8 different stages the loan goes through, and around 25 different Branches(locations) and 400 different Loan Officers I'm keeping track of. So, would I have to do that...
  20. A

    Running In Total in a Pivot Table

    I wish I could send you a print screen :) Anyways, how would I do that formula with in a pivot table? Everytime I try I have issues b/c it won't let me change formulas in the pivot table. Should this be done on my 'raw data' spread sheet first?
  21. A

    Running In Total in a Pivot Table

    Below are my columns, my rows, and the bottom row are the totals. Opened, Credit Pulled, Sub to Proc, Sent to UW, Appraisal Ordered 1 1 0 0 0 6 4 0 0 0 7 7 3 1 2 14 12 3 1 2
  22. A

    Running In Total in a Pivot Table

    PLEASE HELP!! This is making me crazy! *I need the totals to decrease as they enter new stages... *I have 14 total loans 'Opened'...When the loan goes into the next stage 'Credit Pulled' I need the 'Opened' count/total to decrease..and when the loan goes from 'Credit Pulled' on to the next...
Back
Top