+ Reply to Thread
Results 1 to 2 of 2

Summing Problem in Pivot Table

  1. 03-29-2021, 12:57 AM #1
    Jhon Mustofa
    Jhon Mustofa is offline
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Summing Problem in Pivot Table

    hi all...

    how to make summing in Pivot but not agregat in column "budget" for multiple month.
    here this attachment file
    any help, thank in advance..
    john m

    note:
    similiar this link https://www.excelforum.com/excel-cha...e-1-month.html
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-29-2021, 03:50 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Summing Problem in Pivot Table

    Change from SUM of budget to AVERAGE of budget??? Then rename the PT column...
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Table Summing Values
    By grezmel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-29-2018, 05:47 AM
  2. Table to column problem to create dataset for pivot table [Bloomberg data to pivot table]
    By fajfus in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  3. Pivot Table Problem - Double Summing
    By hokkaido19 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-25-2016, 01:55 AM
  4. Grouping and Summing in Pivot Table
    By rish1603 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-07-2015, 11:35 PM
  5. Pivot table not summing the way I want it to.
    By bigguy05641 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-23-2013, 07:12 AM
  6. Problem Summing columns from pivot table
    By VJEF in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-22-2013, 04:45 PM
  7. Summing % Difference from in a Pivot Table
    By IW65537 in forum Excel General
    Replies: 0
    Last Post: 01-12-2009, 11:18 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1