-
(1) = ∑ Invoice Price of Product / ∑ Qty of Product (per customer Last 12M)
-> InCI_AggregatedData(Customer Insights Aggregated Data Data Source), this field is called “Product Avg Price By Customer“ (ProductAvgPriceByCustomer) -
(2) = ∑ (1) of Product Y of all customers in class A / Number of customers in class A that have product Y
Do the same with class B, C , D. -
(6) Overall per product = Average { (2),(3),(4),(5) }