Help needed on set analysis

[#1]

Hi All,

Hope everyone is doing great.

I need small help in indirect set analysis.

I am calculating current year Sales for products which got sales both lat year and this year.

i have tried this using set analysis as given below.

Sum({<Sales= p({<Sales= {"=Sum({1<Year={$(=Max(Year))}>}Sales)>0"}>})*

p({<Sales= {"=Sum({1<Year={$(=Max(Year)-1)}>}Sales)>0"}>})>}Sales)

but the above expression calculating sales for all the products irrespective of the P() condition.

Can someone throw some light around the issue here.

Thanks in advance,

Regards,

Nani

[sunny_talwar]

Sounds good... will try to test this theory out in the mean time (if I get time)

[#3]

Sorry for the late reply Sunny.But i was in training till today and was not able to have a look at it.

The solution worked as expected.

Thanks,

Nani