cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
cshcshh
Calcite | Level 5 cshcshh
Calcite | Level 5

SAS VA 7.2 Crosstab subtotal column divided by the total of another column

Posted 05-02-2018 05:36 AM (1279 views)

1.JPG

Hello, how can I take Appeal Count Subtotal (e.g. 500) / Notice Count Total (e.g. 703) = % (71.1%). 
Notice count & Appeal Count are Aggregated Measure due to Distinct Count.

Thank you.

0 Likes
Reply
1 REPLY 1
FredrikE
Rhodochrosite | Level 12 FredrikE
Rhodochrosite | Level 12

Re: SAS VA 7.2 Crosstab subtotal column divided by the total of another column

Posted 05-02-2018 06:38 AM (1267 views)  |   In reply to cshcshh

You can't!

//Fredrik

0 Likes
Reply

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

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 save with the early bird rate—just $795!

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.

Watch Tips for filtering data sources in SAS Visual Analytics on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎05-02-2018 05:36 AM
  • 1280 views
  • 0 likes
  • 2 in conversation