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.
I've managed to get the data to display correctly in a crosstab:
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:
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.
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.