hide the Filter field if value is not there

[nima94]

Hi

i have filter of group of Customers

if i select a range of date, some of Customer filter color changes to gray which means there is no value of selected date for those Customer Group.

now  instead of being gray, i want to those filter be disappierd  those Gray Group.

[tresesco · Accepted solution]

You can use expression instead of using direct field.

Aggr( [Customer Group], [Customer Group])

[nima94]

thanks it works.

but im using the belloew :

=if(IsNull(Customer Group),'NA',Customer Group)

can you may guide me how i can combine both of them ?

[tresesco · Accepted solution]

Aggr(

if(IsNull([Customer Group]),'NA',[Customer Group])

, [Customer Group]

)

[nima94]

Thanks