BookmarkSubscribeRSS Feed
e487
Calcite | Level 5

Hello all,

 

I'm working with a calculated item which aggregates a percentage value cumulatively. The column it's based on has the data as a percentage of the total within that category. So this calculation should give a percentage running from 100% to 0 within each separate category.

e487_0-1614673754019.png

I've managed to get the data to display correctly in a crosstab:

e487_1-1614673972526.png

However when I'm trying to get the data displayed in a line graph the aggregation goes wrong, instead of aggregating within each group the aggregation happens over all together, which is then displayed by group:

e487_2-1614674290688.png

 

Is there a way to have the line graph aggregate over the categories in the by group and not the month? Either by some option in the line graph or by calculating the aggregation differently.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 0 replies
  • 675 views
  • 0 likes
  • 1 in conversation