I would like to create a calculation in a pivot table using a calculated item and a value from one of the time periods displayed. ie. database contains transactions listing price and quantity. Pivot table contains calculated field = average price per period. calculated item = difference of average price in period 1 vs. average price in period 2. I'm searching for a way to then calculate the value of the difference in price x quantity sold in period 2. How can I do that?