IF Statement - Chart Help

[#1]

Afternoon all,

I have a basic straight table which is pulling sales lead information.  This table is an overview of top accounts by value etc.  It should be pulling through the top accounts for a sales person when selected, but it's not.  It's pulling all data!!

I imagine I need to put some sort of IF statement in but struggling to get it to work.  So for example Count(IF(name = ' ',OPPORTUNITY_COUNT) this doesn't work......any advice? 

[sunny_talwar]

Not sure I understand, would you be able to elaborate with an example?

[#3]

OK so example:

This salesman has 3 active leads but the straight table states 36!!  It seems to be pulling all the leads for all salesman through.....

[Anonymous]

count (ONLY { 1} Responsible)

or

Rank (ONLY { 1} Responsible)

[vinieme12]

where does it state 36 in the snapshot?

also what is the the condition you are trying with the IF statement?

[sunny_talwar]

On the side

Seems like a data model issue to me

[vinieme12]

I think the OP is trying to count on a KEY field

[sunny_talwar]

That could be a problem too . Unless they want to do a DISTINCT count