Hello, I am having trouble with a crosstab report.  I would like to have one column within the crosstab that would display different percents of.

For example, each sub-category would display the percent of compared to the main category and the main category total would display the percent of to the grand total. 

Category 1

Sub 1:       10  22.2% (compared to Cat1 total)

Sub 2:       15  33.3% (compared to Cat1 total)

Sub 3:       20  44.4% (compared to Cat1 total)

  Category 1 total: 45 31.0% (compared to Grand Total)

Category 2

Sub 1:           5  5.0%  (compared to Cat2 total)

Sub 2:         28 28.0% (compared to Cat2 total)

Sub 3:        67 67.0% (compared to Cat2 total)

  Category 2 total: 100 69.0% (compared to Grand total)

Grand total:           145

I hope this makes sense, I can’t figure out how to achieve this.  The other drawback is I cannot create a manual crosstab since the column headings vary depending on the grouping of the report itself.

Thank you for your assistance,

Jeff