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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pivot table calculation using a calculated item and field
- Thread starter cmimb
- Start date
