Like Wise Analysis

[deepakk]

Hi All,

I need to Make a like wise analysis on the basis on Year . I need to pick only those product whos sales Is there in 2009 and the same product Cmparison need to be in in 2010.

I have attach the data file. IN the file example I should not select Product C since it not there in 2009.

Thanks

Deepak

[SunilChauhan]

hi,

i think this will help you

for year 2009

Sum(if(Year='2009', and year='2010',Sales))

good luck

[deepakk]

Sorry This Doesnt Work.........!!!