I am working with truck peddles and specifying a date range. I am trying to specify total dates for each peddle during this date range (i.e. if Iowa has 10 stops for July 1st, that would count as 1 date). Each peddle will have several different stops of various weights. I am trying to get an average of weight based on total peddle dates. My table has an entry with all information for each stop for each peddle.
Peddle Date Range - July 1st, 2017 - July 31st, 2017
Peddle Total Peddles for Month Total Weight Avg. Weight
Iowa 20 100,000 5,000
Minnesota 10 45,000 4,500
Nebraska 15 60,000 4,000
I am struggling with coming up with the total peddles during that month as well as the Avg. Weight. Any help would be appreciated.