2 Replies Latest reply: Oct 15, 2017 10:03 AM by gerry castellino RSS

    Aggregation question

    gerry castellino

      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.

      Sum by agent.PNG