+ Reply to Thread
Results 1 to 4 of 4

Pivot Table Show Values as %

  1. #1
    Registered User
    Join Date
    08-02-2016
    Location
    Milwaukee, WI
    MS-Off Ver
    MS Office 365 Version 2307
    Posts
    9

    Question Pivot Table Show Values as %

    I have a pivot table that I am currently showing three parent fields, then the top ten customers for each parent in the rows. Sales dollars are in columns.

    My goal is to show a % of total parent sales, but the % should be calculated on the full parent value, not just the top ten total that are in the filtered view. Currently, I have a side calculation in the column to the right referencing a separate pivot table that is summing parent sales from the original dataset.

    Is there any way to get this % of total parent sales into the pivot table, or do I have to live with the side calculation?

    Thanks.


    Using MS365, Excel Version 2307

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2508 Win 11
    Posts
    24,959

    Re: Pivot Table Show Values as %

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

    Also, please update your profile to reflect the version of excel you are using.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-02-2016
    Location
    Milwaukee, WI
    MS-Off Ver
    MS Office 365 Version 2307
    Posts
    9

    Re: Pivot Table Show Values as %

    I have added the attachment to this message.
    Attached Files Attached Files

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,067

    Re: Pivot Table Show Values as %

    You can do it using Power Pivot as in the attached version of your file.
    Attached Files Attached Files
    Everyone who confuses correlation and causation ends up dead.

+ 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. How To Show The Values On Pivot Table
    By zanshin777 in forum Excel General
    Replies: 7
    Last Post: 07-10-2020, 04:16 PM
  2. Pivot Table does not show all values
    By dflak in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-15-2018, 03:29 PM
  3. Show/Filter top values in a pivot table
    By spangpang in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-14-2013, 07:39 AM
  4. Why do identical values show up twice in Pivot Table?
    By desperatepivot in forum Excel General
    Replies: 5
    Last Post: 07-12-2011, 05:58 AM
  5. Pivot table - show values as
    By vesapo in forum Excel General
    Replies: 11
    Last Post: 11-29-2010, 11:55 AM
  6. Pivot Table to show row values
    By JimmyA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2009, 10:06 AM
  7. Show values only in a pivot table
    By ymze in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2005, 03:05 PM

Tags for this Thread

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