sum if set analysis

[Anonymous]

hi there,

I want to write;

sum (sales)

filter1 : addmonths -2 (2 months before today)

filter2 : country=germany

can you help me write tihs with set analysis?

thanks.

[Anil_Babu_Samineni]

Perhaps this?

Sum({<DateField = {">=$(=AddMonths(Date(Today()), -2)) <=$(=Date(Today()-1))"}, country = {'germany'}>}sales)

[sunny_talwar]

May be this

Sum({<country = {'germany'}, Date = {"$(=Date(AddMonths(Today(), -2)))"}>}sales)

[Anonymous]

what is the $ for ?

[sunny_talwar]

It is The Magic of Dollar Expansions

[Anonymous]

and my date filter is in 'YYYYMM'

so is it :

=Sum({<country = {'Germany'}, Date = {"$(=Date(AddMonths(Today(), -2),'YYYYMM'))"}>}sales)

(error)

[MK9885]

=Sum({<country = {'Germany'}, Num_Month = {$(=Max(Num_Month)-2)}>}sales)

This may work if you have months in numeric.

Like 1,2,3,4,....12