Set Analysis - sum & min

[#1]

Hi,

I have the following crosstable :

I need to add a column (look at the table below) where :

for each [GA_Date_GAA2]

     needed column = sum(Active_GAA2) / sum({<month_GAA2=min(month_GAA2)>} Active_GAA2)

Regards,

Yacine

[lironbaram]

hei

attch is an example

hope youll find it helpful

[#3]

thank you liron, it was helpfull but there is a small issue with that expression that I can't fix:

=sum(Value)/sum({<Month={"$(=min(Month))"}>} total <Date> Value)

the expression works only when month = 1; the "min(month)" should be calculated for each "date".