Skip to Content
0
Former Member
May 16, 2018 at 08:25 PM

Where [dimension D1] = [dimension D2]

97 Views Last edit May 16, 2018 at 07:33 AM 2 rev

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.

Attachments

table.png (83.3 kB)