So I'm looking to work on some historical prices. I have the data set I want to use (categoized by product type and date). My issues is that each product type sells at a different price, various times throughout the day. So I need a way to calculate the average product price per day, so that I can then plot the change in average prices throughout time.

Is there any simple way to do this? Or will I have to use pivot tables to separate the data set into product and then date (to average the prices).

any help is much appreciated