I am working on a inventory model where I have to calculate average demand. My table looks like this.
ToolID PartNumber DemandDate PartDemand ToolNumber
ToolID is the primary key. Part Number and Tool Number are often duplicated. I am trying to find average for the same part number only which can also be used in future calculation. I would really appreciate it if someone can help me.