IF(
DATEDIFF([Date],TODAY,"day")<2,1,
DATEDIFF([Date],TODAY,"day")<5,2,
DATEDIFF([Date],TODAY,"day")<10,3,
DATEDIFF([Date],TODAY,"day")<15,4,
5)
SUBSET_NONEMPTYCOUNT([ProductID],SUBSET2([ProductID], [CustomerID]))
This formula counts how many times customer bought certain product. Please be aware that the subset formula will populate each field, so for each record with the same combination of [ProductID][CustomerID] there will be the same result. Duplication can be eliminated through aggregation, by choosing "unique values" for this field.
SUBSET_SUM([Value],SUBSET([CustomerID]))
[Rank Recency]+" "+[Rank Frequency]+" "+[Rank Spend]
It looks like you're new here. If you want to get involved, click one of these buttons!