Results 1 to 3 of 3

Thread: Pivot table showing recurring values only once
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2004
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot table showing recurring values only once

    Hi,
    I have an excel sheet given below. The pivot table shows the "Amount" portion correctly but in the "Qty" portion, values which are repeated are shown only once.
    How to show all values in Rows??



    Excel 2007 32 bit
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    1
    Sum of Amount Column Labels
    Comm.
    L / UL
    Qty
    Rate
    Amount
    2
    Row Labels L U Grand Total Item 1
    U
    7.00
    48.56
    340
    3
    Item 1
    682.268
    682.268
    Item 3
    L
    4.00
    44.75
    179
    4
    7.00
    339.92
    339.92
    Item 1
    U
    7.05
    48.56
    342
    5
    7.05
    342.348
    342.348
    Item 2
    L
    12
    41.25
    495
    6
    Item 3
    179
    179
    item 2
    L
    12
    41.25
    495
    7
    4.00
    179
    179
    0
    8
    Item 2
    990
    990
    0
    9
    12.00
    990
    990
    0
    10
    Grand Total
    1169
    682.268
    1851.268
    0
    11
    12
    Sheet: Sheet2

    The Right side portionwith Coloured Heding is the Data and what seen on the Left is actually a Pivot Table, but came out like this only. Now in Row Labels under "Item 1" 7 and 7.05 are shown. But if both values are same asi n the case of "Item 2" only one value is shown but the values in the Column Label section are correct. How to show all values in Rows??
    Last edited by shaju; Oct 16th, 2019 at 02:24 PM.

  2. #2
    Board Regular
    Join Date
    Jul 2004
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot table showing recurring values only once

    Bump...

  3. #3
    Board Regular
    Join Date
    Jul 2004
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot table showing recurring values only once

    Bump

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
  •