+ Reply to Thread
Results 1 to 5 of 5

Divided grand total in pivot (different column)

  1. #1
    Registered User
    Join Date
    01-03-2014
    Location
    indonesia
    MS-Off Ver
    Excel 2007
    Posts
    19

    Divided grand total in pivot (different column)

    Dear all,

    i have some problem in pivot (attached),
    i have some data of qty per month for year 2018 & 2019, which both of them have some grand total.
    When i want to make some %tage (Grand total Qty 2019/Grand total Qty 2018), i couldn't find those "grand total Qty" in calculated field...

    Could anyone here please help me in my problem?
    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-22-2017
    Location
    INDIA
    MS-Off Ver
    EXCEL 2007
    Posts
    106

    Re: Divided grand total in pivot (different column)

    Add Qty field again and change as "Var"
    Select Var field and selection an option year field
    If you add Month, it will show it as month-wise variance.
    I removed Month. Hope this will be your requirement
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-03-2014
    Location
    indonesia
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Divided grand total in pivot (different column)

    the problem is, i want to make a percentage using "grand total 2019/grand total 2019"..(im using "divide" formula)
    what you do in that excel, is "deduction" formula

  4. #4
    Registered User
    Join Date
    01-03-2014
    Location
    indonesia
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Divided grand total in pivot (different column)

    still not solved...can any1 here help me with this problem

  5. #5
    Forum Contributor
    Join Date
    12-22-2017
    Location
    INDIA
    MS-Off Ver
    EXCEL 2007
    Posts
    106

    Re: Divided grand total in pivot (different column)

    Now divided year 2018/year 2019 in percentage. Hope this will be your requirement
    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. Pivot Table needs % of grand total column
    By sharbie in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-24-2019, 06:45 AM
  2. Additional grand total to pivot with percent of grand total
    By avism in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 08-16-2019, 12:26 AM
  3. Need help creating pivot - grand total and grand total as % of column value
    By obionenairobi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-18-2017, 08:00 AM
  4. Pivot Table (Need :- % of Grand Total Column)
    By sam99 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 12-20-2013, 03:56 AM
  5. Splitting Grand Total column in Pivot
    By paulahoward529 in forum Excel General
    Replies: 5
    Last Post: 04-27-2012, 12:15 PM
  6. Pivot Table - Grand Total not the sum of the column
    By Harrold in forum Excel General
    Replies: 2
    Last Post: 10-25-2011, 11:23 AM
  7. Pivot-Sort by Grand Total column
    By jomili in forum Excel General
    Replies: 2
    Last Post: 05-10-2011, 08:34 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