Hi,
Could you please let me know how to define below SAP BO function in Incorta .
=Sum([Extended]ForEach([Item$ITEM];[Item_Category];[Item_Description];[Item_Sub_Category];[Organization_Code]
Where ([Transaction_Type] <>"WIP "
Regards,
Hari.
KHK -- Create an aggregate table that aggregates (Groups) by Item, Item Category, Description, Sub Category and Organization code. Sum the Extended value as the metric. Add a filter at the insight level for "NOT IN 'WIP'"
© Incorta, Inc. All Rights Reserved.