Previous Day Selection

[#1]

Hi All,

i have a pivot table for that i have Date as dimension, i have five expression  and my requirement is like

for the first CRE_DT total value should be next CRE_DT 's INITIAL STOCK.(as per the screenshot matching colours). How to achieve the same.

Thanks in advance.

[preminqlik]

seems to be closing stock and opening stock analysis...

you can do this ,, please post sample data...

[preminqlik]

hi PFA