Yes, It is already the aggreate data, but I need to have the total at the top and It doesn't show if I don't use sum(). Anyways, Thanks for the reply. Will DISTINCT actually help? or is it ok if I use DISTINCT?
Are you summing from a transaction table but displaying this in a chart/table using a dimension that is from another table in your datamodel. If so, could the the links between your tables be creating this doubling of the transaction measure. If the links between the two tables are not unique you can get duplicates.