Hello. I am trying to evaluate the weighted average price per month for a large data set (example attached here). If logical, I would like to create pivot tables with the weighted averages then represent graphically to show price trends as they relate to quantity.
Ultimately, I want to show the correlation between: weighted average cost of multiple products (per month) as it relates to the total quantity (per month) over time and then create graphs for each product.
Help appreciated.
Bookmarks