Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
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