Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can use expression instead of using direct field.
Aggr( [Customer Group], [Customer Group])
Aggr(
if(IsNull([Customer Group]),'NA',[Customer Group])
, [Customer Group]
)
You can use expression instead of using direct field.
Aggr( [Customer Group], [Customer Group])
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 ?
Aggr(
if(IsNull([Customer Group]),'NA',[Customer Group])
, [Customer Group]
)
Thanks