Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
gosh ! that is correct !
let me know where to send the box of chocolates 🙂
Gerry.