get sum value from SAPCode that have it to each suppliers & group by supplier

[#1]

Hi All,

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?

[sunny_talwar · Accepted solution]

Try this expression:

Sum({<SAPCode  = {"=Count(Distinct Supplier) = Count(TOTAL DISTINCT Supplier)"}>}Value)

[#3]

Thanks Sunny,

it's work