Does anyone know if it is possible to have a calculated field in a pivot table that is based on two seperate fields, one a running total, and the other a daily value. I need to calculate:
Market_Value = Face_Value * Price
Where Face_Value is a running total over numerous days, but Price is a single value by day (I don't want to add the price). On any given day I want to multiply the running total of Face_Value for all previous days by the current day's price. If anyone has any ideas it would be greatly appreciated. Thanks.
Market_Value = Face_Value * Price
Where Face_Value is a running total over numerous days, but Price is a single value by day (I don't want to add the price). On any given day I want to multiply the running total of Face_Value for all previous days by the current day's price. If anyone has any ideas it would be greatly appreciated. Thanks.
