Aggregation question

[gerrycastellino]

I have a multi-part aggregation that I'm doing. The last column (Tot by Agent) should be summed up by agent , and should be the same for each agent regardless of Alliance.

I've indicated what I'm expecting.

The Expression that I currently have is this:

sum(

     aggr(

          (

          sum(Calls)

          *

               (

               sum(Calls)

               /

               sum( TOTAL <SalesRep> Calls)

               )

          )

     ,SalesRep)

)

qvw file attached.

Thankx in advance.

[JaMajka1 · Accepted solution]

Hello, try this one. Hope, that helps .

sum(total <SalesRep> aggr(

sum(total <Alliance,SalesRep> aggr(

sum([Calls Last]*[Calls Last])

/

sum(total <SalesRep> aggr(sum([Calls Last]),SalesRep)),SalesRep))

,SalesRep))

BR,

Maria

[gerrycastellino]

gosh !  that is correct !

let me know where to send the box of chocolates 🙂

Gerry.