So, I am trying to create an on-time delivery graph from a table with the promised date, dock date, a calculated column indicating (On-Time) or (Late), calculated column indicating 0 for (On-Time) 1 for (Late). The issue I am running into is when I transfer these columns to a pivot table. I cannot seem to figure out what calculated field i need in order to give me the percentage for On-Time Delievery.
I have count(Num of Orders) - Sum(On-time vs late) / count(Num of Orders) * 100
This formula gives me what I need for the OTD calculation on the table. Unfortunately, I cannot get the data to show what I need on the pivot tables calculated field. Please look at my pivot table...
You can see Average of Field1 (average doesn't matter here, it says the same with count or sum). That calculation is count(Num of Orders). I do not have the dates grouped here. However, it self-groups when we have 5 orders that were sent out on 1/4/17. I want it to be able to say what the 2nd column says. Please let me know if i need to provide more information.
2017-07-11.jpg
2017-07-11_124031.jpg
Bookmarks