title: Using a Pivot Table to run Overtime Analysis
body: <p>I am working on an overtime analysis report in which the data has been imported into Excel (2010).  I need to show overtime and time off hours only.  I've grouped all the time off hours by creating an additional column that only contains those hours (three different codes). Once the pivot tables are created, I'm creating line charts to show any correlation between time off and overtime in a department, month, and by person. It's working great for most of the employees, but . . . </p>
  
  <p>The issue I'm having is that a segment of our employees have overtime built into their schedule, so the OT column values need to be reduced by that number.  (YTD built-in hours is 42).</p>
  
  <p>I've created a calculated field to give me the adjusted OT hours.  The problem is when I create the chart, it includes all the fields - the time off data, the total overtime, and the adjusted overtime.  If I filter out the overtime, the table doesn't do the calculations for the adjusted overtime.  Is there a way to keep just the time off and adjusted overtime hours?</p>