+ 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
    18

    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
    Registered User
    Join Date
    12-22-2017
    Location
    INDIA
    MS-Off Ver
    EXCEL 2007
    Posts
    92

    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
    18

    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
    18

    Re: Divided grand total in pivot (different column)

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

  5. #5
    Registered User
    Join Date
    12-22-2017
    Location
    INDIA
    MS-Off Ver
    EXCEL 2007
    Posts
    92

    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)

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