Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=Aggr(only(
{$<
Date = {">=$(StartDate)<=$(EndDate)"},
Hierarchy = P(Hierarchy) * P(Hierarchy_S)
>} Lead_ID)
,Lead_UID)
----------------------------------------------------------------------------------------------------------------
I have above expression used in straight table but I have 2 lead id for this so no data is seen how can I get both the lead id so what can be the atlernative expression for this
Are you using this as a expression or dimension?
It's a dimension
Are there two fields Lead_ID and Lead_UID? If there are, may you need this?
=Aggr(
Only({$<Date = {">=$(StartDate)<=$(EndDate)"}, Hierarchy = P(Hierarchy) * P(Hierarchy_S)>} Lead_ID)
, Lead_UID, Lead_ID)