How to calculate % like this:
Need to calculate it in a groups, not from whole data. so it should look like this:
How to do it pls? Thanks
You should be able to do this by right-clicking on the measure header and selecting Create and Add Calculation:
Then set Type as Percent of column subtotal:
Hopefully that gets what you want!
You should be able to do this by right-clicking on the measure header and selecting Create and Add Calculation:
Then set Type as Percent of column subtotal:
Hopefully that gets what you want!
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.