title: Cognos 10 multi fact crosstab
body: <p>I am making a cross tab that displays how many people of certain race and ethnic origin signed up for a program by county
  So the rows are a list of each county and the columns are the races sub divided by ethnicity.  </p>
  
  <pre><code>---------------|-----Race1-----|-----Race2-----|-----Race3-----|      
  ---------------|EO1----|EO2----|EO1----|EO2----|EO1----|EO2----|      
  ---------------|--------------------------------------------------------
  COUNTY1        |  
  COUNTY2        |  
  COUNTY3        |
  </code></pre>
  
  <p>The measure I'm using is a count of each person unique id which populates the crosstab correctly.<br>
  The problem Im having is that now I want to add a few more columns at the end of this that shows a percentage total of each race (How many African Americans signed up out of the total number of people, how many Caucasians signed up out of the total number of people, etc)  </p>
  
  <p>But adding that measure changes the rest of them, so is it possible to add these measures without changing the count?  I'm fairly new to cognos so a thorough explanation would be greatly appreciated.</p>
  
  <p>thank you.</p>