Thread: [Solved] Help With Data Analysis/Pivot Table & Chart
View Single Post
 
Old 02-23-2023, 01:27 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 948
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
Is it possible you could explain the formula, so that I can learn.
The only formula is in column D:
=COUNTIF([SO No.],[@[SO No.]])
This surely doesn't need explaining, but COUNTIF function - Microsoft Support

The rest is a standard pivot table & chart.
Column D is what groups the rows of data in the pivot.
Reply With Quote