Button to select dimension based on value of multiple expressions

[bullish35]

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

[rohit214]

hey Ellen,

for background colour

use:

if(meeting=0 and Interest>0 ,RGB(255,0,0))

and

sum({"1(if(meeting=0 and Invester>0)" },Producer)

may it helps you

regard

rohit