/
Average Invoice Price per Customer Revenue Class Last 12M
Average Invoice Price per Customer Revenue Class Last 12M
(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) }
, multiple selections available,