Sum of sales of all products

[niranjana]

Hi,

I wrote this expression :

sum(aggr(sum( {< Product={"=Sum(PrevTL)=0"},Year={"$(=Year(Max(Date)))"},Month={"<=$(=Num(Month(Max(Date))))"},flag={'Onco'}>} TL_Value),Product,[Ret/Hosp]))

But it gives TLValue i.e. sales only for one product. There are 3 such products. Any help is appreciated.

Thanks

Niranjana

[PrashantSangle]

what is your dimension?

[niranjana]

Dimension is Company.

And  I must show sum of sales of all products falling under that company whose prev year sales is zero.

But Product is not the dimension.

Thanks,

Niranjana