Matrix Group % of Total

• jfrance

  SSC Rookie

  Points: 36

  More actions

  December 30, 2009 at 8:47 am

  #218997

  I have been asked to change an existing percent of total in a Matrix report. Currently the report looks like the example below:

  Category 1 Category 2

  Year Set A Set B Set C Total Set A Set B Set C Total Total

  2007 41 32% 26 20% 41 32% 108 84% 13 10% 5 4% 2 2% 20 16% 128 100%

  2008 30 27% 14 13% 46 41% 90 80% 12 11% 5 4% 5 4% 22 20% 112 100%

  The user would like the Set %'s to be a % of the Set within the Category as seen below:

  Category 1 Category 2

  Year Set A Set B Set C Total Set A Set B Set C Total Total

  2007 41 76% 26 84% 41 95% 108 84% 13 24% 5 16% 2 5% 20 16% 128 100%

  2008 30 71% 14 74% 46 90% 90 80% 12 29% 5 26% 5 10% 22 20% 112 100%

  In a nutshull, instead of the Set %'s being a % of row total, the user would like the set %'s to be a % of Set within Category & year. (e.g. 2007 Set A totals to 54)

  I have attempted to do so by using a different Matrix Group and the correct answers is given but the results are displayed on different lines and is not presentation quality.

  Any help is appreciated.