Results 1 to 2 of 2

Thread: Pivot Table Repeating Values When i Want the Sum of Them
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2019
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy Pivot Table Repeating Values When i Want the Sum of Them

    I have a spreadsheet which has some single columns of numbers which i want to pivot (rather than using COUNT) to show occurrences of entries.

    But the pivot table is just repeating the values. I am dropping the column header into ROW and VALUE. The point is also that i know for example that there are two or three occurrences of the zero entry so my guess was that the right hand column would reflect that.

    0 0
    2 2
    3 3
    6 6
    8 8
    15 15
    25 25
    35 70
    40 40
    43 43
    61 61
    62 62
    64 64
    67 67
    70 70
    72 72
    79 79
    95 95
    129 129
    150 150
    270 270
    330 330
    661 661
    668 668
    801 801
    1061 1061
    1290 1290
    2136 2136
    4360 4360

    Whats going on here.....?
    Last edited by Atlas87; Sep 18th, 2019 at 07:56 AM.

  2. #2
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,815
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Pivot Table Repeating Values When i Want the Sum of Them

    I'd guess your value field is not set to Count.

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
  •