Thread: [Solved] Help With Data Analysis/Pivot Table & Chart
View Single Post
 
Old 02-23-2023, 03:43 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Quote:
Originally Posted by tomohawk View Post
How did you calculate the percentages.

2023-02-23_223931.png


Right-click somewhere in the values area of the pivot (column G in my file, column K in your latest file) and choose Value field settings…
Reply With Quote