Excel 2013 – % value in a pivot table not working

Hi

I have raw date which i pivoted

Row

Column A = Team Name

Values

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 *