Excel 2013 – % value in a pivot table not working


I have raw date which i pivoted


Column A = Team Name


Column B =  Count of Team Name by counting unique number against each person

Column C =  Number of Developers (SUM of those flagged as Develoepers)


How can I show the number of developers as a % rather then a SUM


I tried % of Column Total  >using  show values as but that doesnt give the correct %

By: Razwan Iltaf

Leave a Reply

Your email address will not be published. Required fields are marked *