Last n period (trigger)

[nicogene]

Dear all,

I try to get the last 12 periods by clicking on the tab 2 (with implementation of an action) .qvw is attached
With max formula max (Period), it works with the last period.
but max (Period-12) doesn't work.

Thank you for your help

Best regards,

Nicolas Généré.

[#2]

Hi,

please use   =AddMonths( (max(Period)),-12)

Good luck!

Rainer

[bismart]

Use

=addmonths(max(Period),-12) as your expression for max Period - 12