Aggregations Result to Wrong Sum Total.

[maverickkub]

Hi. I am working with a data set that poses me to create an aggregation which is correct when u drill down to a particular level but when the sum total is calculated for it the colum sub totals and totals are completely wrong.Is there a way to sum up plain aggregations? I m posting a screen shot of the issue that i am facing.Please Observe that the individual figures are fine but when you look at the subtotals and totals it yeilds absurd high totals.

[BeverlyBrown]

Hi @maverickkub, if you haven't already, please contact Technical Support, which is best equipped to diagnose what's happening. To see the ways to contact Tech Support, refer to: http://support.sas.com/techsup/contact/index.html Post back to this thread what worked for you!

[Rightside13]

Hi maverickkub,

Did you ever get a solution to the below?

I have a similar issue where SAS is calculating the total rather than simply giving the total of the column.

[acordes]

This is no technical issue, welcome to aggregated measures.

I would need more information about the table behind. 

What is the aggregation context, sum?

several rows of data are condensed in 1 line of the cross table?