I have a raw data sheet with Week, Dept. Error Occurred, Error Code, # Errors, Volume for Week, Errors/Volume, NonRepeat Volume, Goal and NonRepeat Goal as column headers.
In order to create pivot charts from this data I had to add the NonRepeat Volume column and use
=IF(COUNTIF(E$2:E2,E2:E2)=1,E2,"") to have the volume only show up once for each week.
I need to do something similar for the Goal Value, but the Goal Value changes based on Week and Dept. I figured out how to show it on each row, but now I need to just have it shown once for each dept. per week. For example, Goal of 7 should only be shown once for the columns 2-5 since those are the only columns that are Office/Week 1/1.
Any help is much appreciated.
http://hotfile.com/dl/129730245/831fdc4/Social_Internal_Errors_for_upload.xlsx.html
In order to create pivot charts from this data I had to add the NonRepeat Volume column and use
=IF(COUNTIF(E$2:E2,E2:E2)=1,E2,"") to have the volume only show up once for each week.
I need to do something similar for the Goal Value, but the Goal Value changes based on Week and Dept. I figured out how to show it on each row, but now I need to just have it shown once for each dept. per week. For example, Goal of 7 should only be shown once for the columns 2-5 since those are the only columns that are Office/Week 1/1.
Any help is much appreciated.
http://hotfile.com/dl/129730245/831fdc4/Social_Internal_Errors_for_upload.xlsx.html