how to make this aggregation with sum?

[rcandeo]

Hi, I need to make a sumarization using aggregation and it´s not working for me. Anyone can help me with and example or the correct syntax?

Consider this fields:

customer

order number

amount

hours in telephone

The hours in telephone has the total time that the sales person used for this cliente in telephone, and each register has the same number.

So I need to sumarize the hours total for all customers but I need to agregate by customer, cause if I don´t do that it´ll multiply by the numbers of orders.

Thank You

[jpapador · Accepted solution]

I'm not 100% sure what you are looking for but try:

Sum(Aggr(Sum(DISTINCT [Telephone Hours]), Customer))

[Nicole-Smith]

Maybe:

sum(total <customer> [hours in telephone])

[Anonymous]

How do you want to present it?  If it is a chart where Customer is a dimension, the expression will be:

sum([hours in telephone])

[rcandeo]

That´s perfect. Thank you all for helping me.