How can I calculate the Share of Product Type for each Delivery Number?
In the enclosed screenshot, I'm trying to calculate the yellow column. I tried by using the PU_X functions, also combined with 'DOMAIN_TABLE', but I couldn't get any kind of result.
Page 1 / 1
Hi Andre,
try this
pu_count(DOMAIN_TABLE ( "Table"."Product_type","Table"."Delivery_number"),("Table"."Delivery_number"))
/
pu_count(domain_table("Table"."Delivery_number"),"Table"."Delivery_number")
Works perfectly, thank you!!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.