+ Reply to Thread
Results 1 to 7 of 7

Pivot table - "show values as" - trouble getting the correct "% of row" totals.

  1. #1
    Registered User
    Join Date
    11-03-2015
    Location
    Alameda, Ca
    MS-Off Ver
    Microsoft Office Professional Plus 2010 version:14.0.4760.1000 (64-bit)
    Posts
    3

    Pivot table - "show values as" - trouble getting the correct "% of row" totals.

    I have a Pivot Table with values:

    Hats Shirts
    Jan Feb Mar Total Jan Feb Mar Total Grand Total
    25 30 45 100 40 65 70 175 275

    Jan has 65 items with 25 hats and 40 shirts.
    I want Jan Hats to show 38% (of the total Jan items) and Jan shirts to show 62% (of the total Jan items) for a total of 100%.
    In the "show values as" option in the pivot table I've tried the % of row total, % of parent row total, etc. but can't get it to show the correct percentages.


    How do I get the pivot table to show the percentages below????

    Hats Shirts
    Jan Feb Mar Total Jan Feb Mar Total Grand Total
    38% 32% 39% 36% 62% 68% 61% 64% 100%

    Thank you in advance.

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,869

    Re: Pivot table - "show values as" - trouble getting the correct "% of row" totals.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    11-03-2015
    Location
    Alameda, Ca
    MS-Off Ver
    Microsoft Office Professional Plus 2010 version:14.0.4760.1000 (64-bit)
    Posts
    3

    Re: Pivot table - "show values as" - trouble getting the correct "% of row" totals.

    Here is the example of the pivot table with total number of items by month.
    In each month I want to show the % of hats and the % of shirts as a % of the total for that month.

    See attachment.
    Attached Images Attached Images

  4. #4
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Pivot table - "show values as" - trouble getting the correct "% of row" totals.

    add the file, not the picture

  5. #5
    Registered User
    Join Date
    11-03-2015
    Location
    Alameda, Ca
    MS-Off Ver
    Microsoft Office Professional Plus 2010 version:14.0.4760.1000 (64-bit)
    Posts
    3

    Re: Pivot table - "show values as" - trouble getting the correct "% of row" totals.

    excel file attached
    Attached Files Attached Files

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Pivot table - "show values as" - trouble getting the correct "% of row" totals.

    Do you have power pivot?
    Remember what the dormouse said
    Feed your head

  7. #7
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Pivot table - "show values as" - trouble getting the correct "% of row" totals.

    My suggestion in the appendix
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Display "TEXT" in "Values" field in PIVOT TABLE using VBA!!
    By meus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-05-2015, 09:56 AM
  2. Display "TEXT" in "Values" field in PIVOT TABLE using VBA!!
    By meus in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-04-2015, 06:14 AM
  3. Replies: 3
    Last Post: 01-02-2014, 02:15 PM
  4. Replies: 1
    Last Post: 06-06-2013, 06:28 PM
  5. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  6. Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working
    By redders in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2011, 03:52 PM
  7. Replies: 0
    Last Post: 02-01-2006, 03:35 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1