how do i sum(if) this?

[amien]

Expression : SUM(IF(Team = 'Team2' and Company = 'CocaCola',Value)

Dimensions: ID, Name, Team, Company

606, JamesBond, Team1, Qlikview, 300

600, JamesBond, Team2, CocaCola, 500

result in pivot:

JamesBond 500

Expression works fine in these this case

What i want is that IF the combination Team2 and CocaCola doenst exist, Then it should take the value of Team1. Example:

606, JamesBond, Team1, Qlikview, 300

600, JamesBond, Team2, CocaCola, 500

606, Pino Team1, Qlikview, 300

Pivot:

JamesBond 500

Pino 300

SUM(IF(Team = 'Team2' and Company = 'CocaCola',Value,IF(Team = 'Team1' and Company = 'Qlikview',Value))

Doesnt work .. because the output will then be

Pivot:

JamesBond 800

Pino 300

Mind the dimension ID.. same person can have two IDs

Thanks in advanced

[johnw]

How about this (untested):

if(count(if(team='Team2' and Company='CocaCola',Name))
,sum(if(team='Team2' and Company='CocaCola',Value))
,sum(if(team='Team1' and Company='QlikView',Value)))