title: Cognos Percentage per Category of a total
body: <p>I have a cross tab report which has the following</p>
  
  <p>On the labels on the side are the types of commodities bought
  On the top labels are the shop names
  The data consists of number of units sold</p>
  
  <p>Example:</p>
  
  <pre><code>         Shop1         Shop2          Shop3      Total
  Toys      25            50             25         100
  Cars
  Trains
  </code></pre>
  
  <p>I am new to Cognos but what i want to do is get the percentage of per shop of how many items were sold per category.</p>
  
  <p>So for example if i sold 100 toys in total and i have 3 shops. I want the whole value of number of toys for shop 1 to be 25 items sold which is 25% of the total items sold that month and 50 items for shop 2 again worth 50% of the total items sold for that month</p>
  
  <p>Does anyone know how to do this in a cross tab?</p>
  
  <p>Thanks</p>