Further working on it I can see that the difference between the two worksheets is that the calculation P/T is computed using Template Id, Level Id, Date Completed, and Component Name in the SAMPLE TREND DATA worksheets and only Template Id, Level Id and Component Name in the SAMPLE P/T sheet.
If I put Data Completed in either the column or row on the SAMPLE P/T sheet then the calculation works, but then chart looks like it does below (not what I want). Any ideas on how to get this calculation to work properly and use the right fields without having to show them on the chart? BTW the calculation is as follows:
IF(Avg([Spec Limit - Max Float]) = Null) OR Avg([Spec Limit - Min Float]) = Null Then
6*WINDOW_STDEV(Avg([Result Value]))/(AVG([Spec Limit - Max Float])-AVG([Spec Limit - Min Float]))