Hi ,

I am having a pivot table with Columns Delta , and Demand .


I am trying to create a calculated field NetDemAvbl. based on this condition:

If my previous's week value of Delta is < 0 , NetDemAvbl = Demand - Delta

else NetDemAvbl = Demand .

My question is how do I extract last week's DELTA in Calculated field formula ?

Please give your suggestions.

Appreciate all your help.

Warm Regards,
Sunvin