Maximum Salary Employee type problem in pivot table

[sumitratnani]

Hi,

Could anybody help me with following scenario.

Fields:

Client

Division

Account Executive

Income_Brought_By_Account Exec

Client may belong to multiple Divisions.

Each Client can have multiple Account Executives which bring income for that client.

I want a table as below..Where Account Exec Column gives Primary Executive for that Client in that Division(Who brings Max Income for that Client in that Division)

I tried multiple ways, couldn't get the result.

PLease help.

[Anonymous]

Try multibox or crosstab

[sumitratnani]

(Data Stroke for Confidentiality)

This is the actual scenario. Clients are C1 C2 C3 C4.

There are two expressions :Rank and Account Exec(Gives Primary Account Execs)

Let me know If I have to clearify further.