1 Reply Latest reply: Sep 27, 2011 1:50 AM by rohit gupta RSS

    Button to select dimension based on value of multiple expressions

    Ellen Blackwell

      Hello,

       

      I am displaying a straight table with a single dimension (Producer) and various expressions (including, Meetings, Interest, and Opportunity). I would like to do two things:

       

      1. Set the background color, for the entire row, when Meetings=0 and Interest>0
      2. Create a button that, when clicked, displays only the Producers with Meetings=0 and Interest>0

       

       

      For simplicity's sake, I have uploaded an image displaying only the relavent expressions:

       

      Meetings:

        =count(distinct if([Meeting Type]='In-Person' and [Activity Type]='Meeting' and [Activity Cancelled]<>'Y',(Activity_ID)))

       

      Interest:

        =Column(3)+Column(4)+Column(5)

       

      Opportunity:

        =if(Column(12)>0 and Column(11)=0, 'Opportunity', '')

       

      Your suggestions are greatly appreciated!

      Thank you,

      Ellen