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 (1590 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 (1578 views)  |   In reply to cshcshh

You can't!

//Fredrik

0 Likes
Reply

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore 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
  • 1591 views
  • 0 likes
  • 2 in conversation