sales value in SKU wise

[ajsjoshua]

Hi all,

I am using the formula =Sum({$<Years = {$(=max(Years))},MonthID1={$(=Max(MonthID1))},Years=,Months= >}Sales)

and i am getting the overall sales value for all SKU.

i want sales value for one SKU to be displayed without selecting a particular SKU.

Anyone help me.

Thanks in Advance

Regards,

Joshua.

[tresesco · Accepted solution]

May be this?

=

If(GetSelectedCount(SKU)>0,

          Sum({$<Years = {$(=max(Years))},MonthID1={$(=Max(MonthID1))}>}Sales) ,

          Sum({$< SKU ={SKUValue1},Years = {$(=max(Years))},MonthID1={$(=Max(MonthID1))}>}Sales)

)

[ajsjoshua]

Thank u tresesco its working fine.

Regards,

Joshua.