6 Replies Latest reply: Aug 1, 2012 2:38 AM by Linda Diodato RSS

    Detached list box

    Linda Diodato

      Hi,

       

      I'm trying to build a list box that keeps detached from selections in some specific fileds but my calculated dimension doesn't seem to work.

       

      aggr(

      if(count({$ <Year=, Partner=, PartnerCountry=>} Year)=0

      ,  Client), Client)

       

      Just to give you some background, these Clients have no relation whatsoever with the fields above because nothing has been sold to them in the past, so they are in fact potential Clients. Because of that, if I select a Year or a Partner for example the list would normally show empty. However, I want the list to keep showing no matter what is selected in the fields above.

       

      Can somebody help?

       

      Thanks!