SET ANALYSIS

[#1]

Hello my friends!!

A question about SET ANALYSIS    

I want to show allways the data for December for the previous year in the following scritp:

=Avg({< Month={'Dec'}, Year=, MonthYear=, QuarterYear=,PAÍS=,Country=,NivelJerarquia={1}>}Nota)

What I have to do in the field YEAR in order to show the previous one

Regards!

[maxgro]

=

Avg({<

     Month={'Dec'},

     Year={$(=Max(Year)-1)},

     MonthYear=, QuarterYear=,PAÍS=,Country=,NivelJerarquia={1}>}

     Nota)

[#3]

Many thanks!! it works!