Results 1 to 4 of 4

Thread: Pivot table - Count of numbers above 0
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2014
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot table - Count of numbers above 0

    I've created a pivot table that has 3 columns: User, CreationDate, TargetDate.

    TargetDate has negative, 0, and positive numbers.

    I am trying to build a pivot table that will show the count of numbers greater than 0, and for a particular month of the year. When I do this, the pivot table does not appear to be filtering the dates and is returning the count of all fields greater than 0.

    For example, if I have 71 rows greater than 0, but only 6 for the month of August, the pivot table returns 71.

    What is going on??

  2. #2
    Board Regular
    Join Date
    Dec 2013
    Posts
    84
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot table - Count of numbers above 0

    Are the CreationDate and TargetDate real date fields?

  3. #3
    New Member
    Join Date
    Aug 2014
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot table - Count of numbers above 0

    CreationDate is a date field, and TargetDate is a number (-5, -1, 0, 225, etc). What I want to do is in TargetDate keep all numbers >0 and have all other numbers be null.

  4. #4
    Board Regular
    Join Date
    Dec 2013
    Posts
    84
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot table - Count of numbers above 0

    Assuming User is the leftmost column, right click anywhere on a user and then select filter from the submenu. From here you can filter on the targetdate to only show number greater than zero.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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