+ Reply to Thread
Results 1 to 2 of 2

Pivot Chart Remove Sum of

  1. #1
    Registered User
    Join Date
    07-10-2018
    Location
    California
    MS-Off Ver
    Windows 10
    Posts
    2

    Pivot Chart Remove Sum of

    I have a spreadsheet with two columns showing percentages by commodity already. When I transfer to Pivot table/Chart the columns are coming in as "sum of" I don't want these to sum just to transfer over as the values they are already. I tried changing the field but that didn't work.

    Pivot.PNG
    Last edited by srega03; 07-18-2019 at 06:00 PM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,532

    Re: Pivot Chart Remove Sum of

    It may help someone in attempting to resolve the issue if you could upload the workbook from which the screen shot is taken by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window. Be sure to include at least a few of the values you want to see in the pivot table, so that the person working on the problem will be able to compare their results to yours.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Pivot table/chart - remove "<0 or (blank)" from grouping
    By michellepace in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-07-2015, 08:42 AM
  2. [SOLVED] Pivot table-remove expand and close from pivot layout
    By excelmr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2015, 07:00 PM
  3. Remove (blank) from Pivot Chart
    By tghemy in forum Excel General
    Replies: 1
    Last Post: 03-18-2015, 11:18 AM
  4. Remove Blanks/0s from Pivot Table Chart
    By dksodhi in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-24-2013, 09:32 AM
  5. Powerpivot Calculated Measure to remove blanks from pivot table/chart
    By hbusche in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-17-2013, 01:23 PM
  6. Pivot Chart: Remove "Drop Page Fields Here" box
    By celine in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-01-2009, 10:45 PM
  7. Pivot Chart - Remove Variables
    By Marlyn in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-25-2006, 04:50 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