Forum Discussion
fluctuation value in a column of a Table in Pivot Table
Hi, I have a Table that contains Product, Purchase date, Quantity Purchased, Purchase price & Market Price. I have created a Pivot Table for this Table. the market Price gets displayed on Pi...
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.