Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Pivot Table Percent of Total

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

    Default

    I want to add a new (i.e. keep my summary raw data) column to a pivot table that will give me the current column as a percent of the column's total. Excel doesn't seem to want to let me add this as as anything but a new data row. Here's an example of what I want:





    RepNY%Boston%
    Bob5,00033%100050%
    Jane10,00067%100050%
    Total15,000100%2,000100%


    When I add a the same data field Excel wants to make it a new row (rather than column):









    RepDataNYBoston
    BobSales5,0001,000
    % Sales33%50%
    JaneSales10,0001,000
    % Sales67%50%
    Total15,0002,000
    Total %100%100%



    Seems like this would be a simple thing but I'm missing something.

    Thanks!

    [ This Message was edited by: jmeeko on 2002-04-07 16:13 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Click on and drag the 'Data' field label to the right and then release.

    [ This Message was edited by: Mark W. on 2002-04-07 16:47 ]

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thought for sure I tried that.

    You're the man!

    Thanks.

    Jeff

Some videos you may like

User Tag List

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
  •