only function alterative

[shivam0703]

=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

[sunny_talwar]

Are you using this as a expression or dimension?

[shivam0703]

It's a dimension

[sunny_talwar]

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)