Definition
Rank (Customer Rank or Product Rank) segments customers or products into ordered bands based on their share of total revenue. Rank 1 represents the highest-revenue group, higher rank numbers represent progressively smaller revenue contributors, and a special “no-revenue” rank (Rank N+1) is used for entities with zero revenue (Products/Customers with no revenue).
Number of Ranks is defined in the Ranks section of the Configuration Step.
Formula
Customer Rank
CustomerRank = ( (N+1)-roundup( ([CumulativeRevenueOfCustomerRankedByIncreasingOrder]/Customers[TotalRevenueOfAllCustomers]) * N ) )
Product Rank
ProductRank = ( (N+1)-roundup( ([CumulativeRevenueOfProductRankedByIncreasingOrder]/Products[TotalRevenueOfAllProducts]) * N ) )
-
N – Number of revenue-based ranks configured.