title: Visualize sum of column percentage for multiple response set variables
body: <p>I'm trying to understand how to visualise the sum of column percentages in some tabulations of multiple variables.</p>
  
  <p>suppose that i have defined the variable $q12 as a multiple response set of categorical values of the variables sq12m1 sq12m2 sq12m3 sq12m4 sq12m5. </p>
  
  <p>i could have cases with values only in sq12m1 or cases with values in all of those. 
  if i want to see how many times any brand appear in any of those sq12m1 to sq12m5 i am using this:</p>
  
  <pre><code>CTABLES
    /VLABELS VARIABLES=$q12 DISPLAY=DEFAULT
    /TABLE $q12 [C][COUNT F40.0, COLPCT.COUNT PCT40.1]
    /CATEGORIES VARIABLES=$q12 ORDER=A KEY=VALUE EMPTY=INCLUDE TOTAL=YES POSITION=AFTER 
      MISSING=EXCLUDE.
  </code></pre>
  
  <p>and it will generate this:</p>
  
  <p><a href="https://i.stack.imgur.com/eK82Y.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eK82Y.png" alt="frequencies"></a></p>
  
  <p>how can i sum the column percentages? using this syntax the total is always 100%, i would like to visualise the sum (which in this case is 215.10%) which represents the average number of mentions...</p>
  
  <p>do you know how to do it?
  thanks!!!</p>