Where [dimension D1] = [dimension D2]

[Former Member]

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.

[jyothirmayee_s]

Hi,

Try Relativevalue([FiscalPeriod];-1)

Thanks,

Jothi