Hi all,
I need to obtain the previous month's stock volume.
Fiscal Period and Volume are data that I have. Previous period is a variable. I want to derive the 4th column.
I tried to create a variable : Prev mth vol = [Volume] where ([Fiscal period]=[Previous period]). But it showed blanks.
Can someone advice how should the formula be written? Thanks in advance.