Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.
Current status: https://keepboardsalive.com/
Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
If we do not hit our goal we will be forced to close the site.
Current status: https://keepboardsalive.com/
Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum
Private Group for paid up members of Boards.ie. Join the club.
Private Group for paid up members of Boards.ie. Join the club.
Excel 2013 Pivot Tables
-
10-08-2018 02:08PM#1
Comments
-
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.
0
Advertisement