Hello,
I have 4 columns of data in an excel spreadsheet. The first column is "Week", the second is "Lane", the third is "Units" and the fourth is "Performance."
Week Lane Units Performance
1 Miami-US to Japan 298 Late
2 Miami-US to Japan 296 On Time
3 Miami-US to Japan 296 On Time
I'm trying to calculate a weighted On Time Performance metric by week using an excel pivot table (as well as the units) but I can't figure out how to do so using the calculation options. If anyone has any tips, I'd love to hear them. I can do this using formulas but I want the user to be able to select and choose the performance based on a variety of options. I've included a picture summarizing what I'm looking to do if it helps.
Thanks!
EvanExcel Screenshot.JPG
Bookmarks