Difference between Total() and Sum()

[nikhilgarg]

Hello ,

Can anyone tell me the difference between total()  and sum() ?

[alexandros17 · Accepted solution]

Sum is an aggregated function while total is not a function but is used in function:

Es.

Sum(Total Sales) means that you are doing the sum of sales disgregarding all dimension in your graph or chart

Hope it helps