DIMENSION VALUE ONE YEAR AGO

[antoniodneto]

Hi Guys,

Can you help me?

I have in my table DATE,STATUS.

I want to create a new dimension DATE_Y_AGO.

The result is something like IF DATE = MAX(DATE) then STATUS = MAX(DATE,12). I want to return how was the STATUS one year ago to compare.

Any ideas?

Tks a lot!

[antoniodneto]

@Channa,

Can you help me build on my script that I sent you through private message?