Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
)
Thank u tresesco its working fine.
Regards,
Joshua.