+ Reply to Thread
Results 1 to 13 of 13

Pivot Problem

  1. #1
    Registered User
    Join Date
    11-17-2019
    Location
    MP
    MS-Off Ver
    2010 2013 2016
    Posts
    5

    Pivot Problem

    Hello Everyone,
    I am having problem in solving this pivot excel problem Need Help.

    Sample Data of San Francisco Salaries:-

    Question:-

    1.) Add a calculated field named "% Other Pay" (Other Pay/Total Pay), formatted as a percentage with 1 decimal. How many job titles earned only Other pay in 2012?
    2.) Among employees with >=$10k Base Pay in 2012, Did any employee earn more than 50% of their salary from Other Pay? If so, who?


    Thank you

    File Attachment is not working. I will attach file as soon as attachment start working...

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Pivot Problem

    Hi
    file attachment does work but you have to read the yellow banner first

  3. #3
    Registered User
    Join Date
    11-17-2019
    Location
    MP
    MS-Off Ver
    2010 2013 2016
    Posts
    5

    Re: Pivot Problem

    I read it but still not getting file file attachmen. Need Help...

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Pivot Problem

    What goes wrong?

  5. #5
    Registered User
    Join Date
    11-17-2019
    Location
    MP
    MS-Off Ver
    2010 2013 2016
    Posts
    5

    Re: Pivot Problem

    on clicking file attachment box is not opening...

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Pivot Problem

    Is this homework?
    Rory

  7. #7
    Registered User
    Join Date
    11-17-2019
    Location
    MP
    MS-Off Ver
    2010 2013 2016
    Posts
    5

    Re: Pivot Problem

    no just learning excel pivot

  8. #8
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Pivot Problem

    What do you mean by " file attachment box" ? the paperclip icon?

  9. #9
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2019; 365
    Posts
    231

    Re: Pivot Problem

    When posting in Quick Reply (below another user's post), click on Go Advanced:

    1.png

    Then scroll down to Manage Attachments:

    2.png

    Then click Browse, locate your file and select it, click Upload, note the file will appear below, then click Close this window.

    3.png

    Your file will show as attached after you post.
    To show your appreciation
    Click ★ Add reputation!

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Pivot Problem

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  11. #11
    Registered User
    Join Date
    11-17-2019
    Location
    MP
    MS-Off Ver
    2010 2013 2016
    Posts
    5

    Re: Pivot Problem

    Yes, Its the paperclip issue.
    Thank you

    And also

    how do you sort when "Difference from" and "% difference from" as value is used?
    Attached Files Attached Files
    Last edited by abm04; 11-19-2019 at 07:35 AM.

  12. #12
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Pivot Problem

    Quote Originally Posted by abm04 View Post
    Yes, Its the paperclip issue.
    Thank you

    And also

    how do you sort when "Difference from" and "% difference from" as value is used?
    You were asked to fix your thread title - please do so!
    You will no further responses until you do.

  13. #13
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Pivot Problem

    Mrrrr please do not post on a thread that is awaiting compliance with a moderation (ie a request to change the thread title)

+ 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. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  2. Pivot Problem
    By riwiseuse in forum Excel General
    Replies: 8
    Last Post: 03-30-2016, 10:02 AM
  3. Pivot table problem - how to relate 3 sheets' data into 1 pivot table?
    By GRG Stevan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-14-2015, 06:12 AM
  4. VBA Pivot Table: Problem with pivot item visibility
    By rotown21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2013, 03:56 AM
  5. Pivot problem
    By JakeMann in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-17-2012, 09:06 AM
  6. [SOLVED] Pivot Problem
    By rainbowzzzzz in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-12-2012, 07:19 AM
  7. pivot problem
    By Kolacube in forum Excel General
    Replies: 4
    Last Post: 03-28-2011, 07:41 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