Closed Thread
Results 1 to 2 of 2

Pivot table not counting values (but does count based on labels)

  1. #1
    Registered User
    Join Date
    03-23-2013
    Location
    seattle
    MS-Off Ver
    Excel 2007
    Posts
    36

    Pivot table not counting values (but does count based on labels)

    Hello,

    I have column in my table that calculates time in hours between now and ticket open date (ticket open date in B1)
    so, in C1 i have following formula:
    =(now()-B1)*24
    Results are in hours, such as 15, 25, 32, 65 etc

    In pivot table, I would like to see how many tickets with values of less than 24 or more than 48, etc

    My available columns are:
    Region, Ticket#, AgingOpenHr(this new column).

    I tried it different ways, and I cannot get it Less Than and Greater Than work under Values, works if I select grater than or less than in Label, but label does not produce consitent numbers.

    Any help is greatly appreciated.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,044

    Re: Pivot table not counting values (but does count based on labels)

    Also posted in CS forum, so I will close this 1, you can continue on the other thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot Table - Show Row labels horizontally (Not as Column labels)
    By Catsup in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-16-2014, 01:15 PM
  2. vba code to filter pivot table column labels based on cell vaule
    By nailler167 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2013, 09:12 PM
  3. Replies: 0
    Last Post: 07-03-2012, 11:09 AM
  4. Pivot table labels based on comma delimited cell values
    By kran05ae in forum Excel General
    Replies: 2
    Last Post: 01-25-2010, 08:25 AM
  5. [SOLVED] Pivot table count function not counting all data.
    By Irma in forum Excel General
    Replies: 3
    Last Post: 05-17-2006, 04:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1