1 Reply Latest reply on Dec 13, 2013 1:07 PM by Andrew Ball

    SUM values where a certain dimensions are duplicated

    Tim Benschop

      Hi all,

       

      I am struggling with something and I will explain it via a simplified example:

      Payment, Customer and Amount are all dimensions.

       

       

      Payment Customer Amount

      1 BMW 20000

      2 VW 30000

      3 BMW 1000

      4 VW 5000

      5 VW 6000

      A function like: Aggregate(Amount, BY=Customer)

      This has to be aggregated on the Customer level and has eventually look like this:

      Customer Amount

      BMW 21000

      VW 41000

      This is for 10.000 customers.. I am sure that it is really easy but I can't figure out how... Help is very much appreciated!

      Thanks in advance!

      Tim