Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel 2013 Pivot Tables

Options
  • 10-08-2018 2:08pm
    #1
    SportingFun
    Registered Users Posts: 74 ✭✭


    Hi,

    I have a excel 2013 pivot table dilemma that I require support for please?

    I have the attached source data and I require the attached outcome

    I am happy to add calculations to the source data however when I did this I could not get the percentages to display as percentages within the pivot almost like the pivot table is expecting to calculate the percentage
    Tagged:


Comments

  • Options
    #2
    dulpit
    Registered Users Posts: 10,749 ✭✭✭✭dulpit


    SportingFun wrote: »
    Hi,

    I have a excel 2013 pivot table dilemma that I require support for please?

    I have the attached source data and I require the attached outcome

    I am happy to add calculations to the source data however when I did this I could not get the percentages to display as percentages within the pivot almost like the pivot table is expecting to calculate the percentage

    I did this by adding a bunch of calculated fields:
    Executed (assuming this is the sum of Passed and Failed)
    Total (sum of all)
    PassedPct (Passed / Total)
    FailedPct (Failed / Total)
    BlockedPct (Blocked / Total)
    InProgressPct (In Progress / Total)
    UntestedPct (Not Run / Total)
    ExecutedPct (Executed / Total)
    Adding all of these did end up as values, not percentage, but then you can highlight values, right click and format cells, pick percentage as type.

    The fancy cells/etc is up to you, I've attached what I threw together.

    458021.PNG


Advertisement