This content has been marked as final. Show 2 replies
i want to ask something from my problem.
i want to get sum value from SAPCode that have it to each suppliers and group by supplier.
for data sample
and want to get the result
currently i've get the list SAPCode that matched for each supplier and only 2
with editor expression and use variable
Aggr(if ($(var_CountGroupBySupplier) = $(var_TotalSupplierBaseOnSAPCode), SAPCode), SAPCode)
variable var_CountGroupBySupplier = Count( Supplier )
variable var_TotalSupplierBaseOnSAPCode = Count( distinct TOTAL Supplier)
and for count match SAPCode that is matched is 2,
how i can get sum value from SAPCode that have it to each suppliers and group by supplier?