Pivot table Weighted average not the sum of its parts - why?
Results 1 to 2 of 2

Thread: Pivot table Weighted average not the sum of its parts - why?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2012
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot table Weighted average not the sum of its parts - why?

    I have a pivot table that is working out weighted average, now my issue is that the Grand total does tie back to the line by line version, any idea why?

    The Grand total is saying 78.56% but if I calculate it line by line its 78.14% what is causing the difference?

    Item Weighted Avg Qty Weighting WTD
    A 68.86% 82,275.00 2.42% 1.67%
    B 75.24% 411,112.50 12.09% 9.09%
    C 77.65% 97,500.00 2.87% 2.23%
    D 57.99% 3,150.00 0.09% 0.05%
    E 80.60% 1,701,300.00 50.01% 40.31%
    F 71.49% 56,150.00 1.65% 1.18%
    G 78.23% 7,950.00 0.23% 0.18%
    H 72.34% 104,625.00 3.08% 2.22%
    I 79.22% 208,975.00 6.14% 4.87%
    J 76.53% 435,487.50 12.80% 9.80%
    K 77.77% 90,875.00 2.67% 2.08%
    L 70.85% 29,400.00 0.86% 0.61%
    M 76.16% 165,300.00 4.86% 3.70%
    N 67.99% 7,525.00 0.22% 0.15%
    Grand Total 78.56% 3,401,625.00 78.14%



    I hope that makes sense,

    Cheers for the help.

  2. #2
    Board Regular pbornemeier's Avatar
    Join Date
    May 2005
    Location
    Virginia Beach, VA USA
    Posts
    3,636
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Pivot table Weighted average not the sum of its parts - why?

    Figuring the distribution of the Quantity column over its total does result in the values in the Weighting column.
    How is your PT data laid out?
    Which of those columns are in each PT Field (column, row, value)
    What does WTD stand for?
    Phil

    - Use CODE tags to keep your code formatted. See: BB Tags
    - How to attach Screenshots
    - Try searching for your answer first, see how
    - Test and validate results for all code on a copy of your worksheet!! How do you use the code you just found?
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

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
  •