Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

percent by row

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

percent by row

I need to convert below table into crosstab. Month would be rows, range would be columns and measure has to be % of balance by row (per month).

 

I've tried "Percent of Total", but it calculates % of overall total but not % of row total.

 

Any help is greatly appreciated.

 

monthrangeCount Balance 
Jan-15<3018 $              996,958
Jan-15<6083 $        324,331
Jan-15<80153 $        271,065
Jan-15<9091 $        2,761,917
Jan-15<10058 $        9,227,751
Jan-15100+3 $              995,563

Accepted Solutions
Solution
‎09-25-2015 06:23 AM
New Contributor
Posts: 4

All Replies
Solution
‎09-25-2015 06:23 AM
New Contributor
Posts: 4

Re: percent by row

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 423 views
  • 0 likes
  • 1 in conversation