Getting value from previous column, from previous week

[#1]

Hello.

I've got something like this:

and I've got a question about this:

How could I make CurrentStock be equal to Bilans from previous week (Fabric_CW)?

I've tried a few solutions and none of them was able to get value from another week(for example, column() gets values only from the same week and isn't able to get values from another set of fields - here, from previous week)

[#2]

Hi Sunny,

                I have the same requirement. But before function works only with pivot table what if we need to represent this in a bar chart? If you have any work around for this please share it. Much appreciated !!

Thanks