Hi Buddy,

Yes, . I want to apply the calculation directly to the pivot table.

The Formula in this situation will be :

=IF((Delta) Prev_week < 0, Demand - (Delta)Prev_Week , Demand)

Can you please tell me how do arrive at (DELTA) previous week. and use it in the calculated_fields formula?

Thanks for your time,
warm regards,
Sunvin