set analysis

[#1]

hello

how can i find sales of last six month 

for a given countries=india ,usa,china(in set analysis)

thanks in advance

[robert_mika]

Could you add sample of your data?

[#3]

hello robert ,i just need a general expression using set analysis

[robert_mika]

Try:

Sum({$<MonthID = {“>=$(=Max(MonthID) – 5)<=$(=Max(MonthID))”},Country ={USA,India,China} >} Sales)