You use PivotTable to aggregate some data, e.g. if in row part you have dates and in value one Qty, you calculate sum of qty per day, month, year, etc. (or other aggregation). Same for market price, you aggregate it for some period of time. As variant you may use min or max of it, or both. That's how PivotTable works, otherwise you need just Table. Perhaps you had other idea in mind, but that's better to discuss on sample file.