Bypassing field (filter) is not working in aggr function

[aatish12345]

Hi All, I have a expression in below format

Aggr(

If(Aggr(NODISTINCT Max(date(SampleDateField)), country, state, city) = [SampleDateField]

,avg([SALES])), country, state, city,SampleDateField)
       )

In above expression I want to bypass [EmployeeName] field, so that after selecting EmployeeName from filter the result of expression should not change., but it is getting difficult for me to achieve the same , as after adding that field in set analysis , the filter is still getting applied to the result. I have also used Only function but it is also not helping.

Please suggest any workaround

Aatish 

[Chanty4u]

Try this s

Aggr(

    If(

        Aggr(NODISTINCT Max(date(SampleDateField)), country, state, city) = [SampleDateField],

        Avg({$<EmployeeName=>} [SALES])

    ),

    country, state, city, SampleDateField)

[aatish12345]

Let me get back