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:
For simplicity's sake, I have uploaded an image displaying only the relavent expressions:
=count(distinct if([Meeting Type]='In-Person' and [Activity Type]='Meeting' and [Activity Cancelled]<>'Y',(Activity_ID)))
=if(Column(12)>0 and Column(11)=0, 'Opportunity', '')
Your suggestions are greatly appreciated!