CTables - colpct but with count total

Posted by Jignesh Sutar-3 on Nov 26, 2013; 1:12pm
URL: http://spssx-discussion.165.s1.nabble.com/CTables-colpct-but-with-count-total-tp5723325.html

Hi,

Is it possible to replicate the custom table below but instead of showing the total column percentage as 100% to display the count for the total row only i.e. showing the base size of the column percentages?

Would be very handy if this was possible...

get file = "C:\Program Files\IBM\SPSS\Statistics\22\Samples\English\Employee data.sav".

ctables /table jobcat [c] by gender [c][colpct]
  /categories variables=jobcat total=yes.

Thanks in advance,

Jignesh