BookmarkSubscribeRSS Feed
Obsidian | Level 7
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.
bottle n cases error.png
Community Manager

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: Post back to this thread what worked for you!

Check out the SAS Explore forum. You'll find posts summarizing more than 100 presentations.

Fluorite | Level 6

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.







Rhodochrosite | Level 12

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?



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 4 in conversation