+ Reply to Thread
Results 1 to 4 of 4

Excel Pivot chart - Grand total

  1. #1
    Registered User
    Join Date
    08-28-2018
    Location
    Draper, Utah
    MS-Off Ver
    2013
    Posts
    2

    Excel Pivot chart - Grand total

    Hello,

    I am attempting to finish my interactive dashboard by getting a percentage from values I have placed in the pivot tables.

    My end goal: Take the number (#) of skills requested and divide them by the total (#) of job postings. (attached)

    Currently, I am not sure that the way I have the pivot table in the dashboard is actually calculating as I previously stated for my end goal objective. I may have been looking at it too long, as the second set of eyes would be greatly appreciated. (attached)
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-28-2018
    Location
    مشهد
    MS-Off Ver
    ghiasi
    Posts
    2

    Re: Excel Pivot chart - Grand total

    that's great
    thx
    Last edited by drmajidghiasi; 08-29-2018 at 12:01 AM. Reason: نیاز نیست

  3. #3
    Registered User
    Join Date
    08-28-2018
    Location
    مشهد
    MS-Off Ver
    ghiasi
    Posts
    2

    Re: Excel Pivot chart - Grand total

    I similar problem

  4. #4
    Registered User
    Join Date
    08-28-2018
    Location
    Draper, Utah
    MS-Off Ver
    2013
    Posts
    2

    Re: Excel Pivot chart - Grand total

    Ok so I got a little further last night.

    I am attempting to divide the total skills in each row by the grand total of job postings.


    skills.PNG


    grand total.PNG

    I need to do this formula: =(skills cell)/(grand total) (both are highlighted in red in the above attachment) and in my excel pivot table it would be =(C15)/(B97) so I get a percentage end result of 22.98%

    job skills percentage.PNG

    However, currently I cannot get this to figure in my excel pivot table.

    I have attempted to go into, from the pivot table, >Analyze>Field, Items, & Sets >Calculate Field

    Calculate Fields.PNG

    I have added the field

    added field.PNG

    Then I clicked OK, however I end up with errors: #DIV/0! or just zero (0).

    Any insight on where I may be going wrong or what I may need to do the pivot table is attached to an interactive dashboard so when I update my data I need it to also update.

+ 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