In order to accomplish your goal in CR 8.5, you need to create a manual crosstab. You can't use the wizard.

1) Create groups as you have

2) Create Column Labels

3) Create formulas that will be placed in the detail section of the report. These formulas will be something like:

@Cat1_Fld1

If

Category = Cat1

Then

FLD1

Else

0

Based on your example, you'll need to create 4 formulas: Cat1_Fld1, Cat2_Fld1, Cat1_Fld2 and Cat2_Fld2. Each formula will be similar to the one shown above.

4) Right-click on each of these formulas--once they're in the detail section--and Insert Summary. You're going to Sum the values (assuming FLD2 and FLD2 have numeric values) both the subgroup and the primary group.

5) Hide or suppress the detail section.

6) Create two formulas at the subgroup level, each of which will calculate the percentage for its respective column. Each formula will look something like this:

@Cat1_subgroup_percentage

If

Sum(@Cat1_Fld1,subgroupfield) <> 0

Then

((Sum(@Cat1_Fld1,subgroupfield) - Sum(@Cat1_Fld2,subgroupfield)) / Sum(@Cat1_Fld1,subgroupfield)) * 100

Else

0

7) Next you'll create formulas for the Row totals at the subgroup level. The row totals formulas will look like this (alternate, you can just right-click on the Fld1 and Fld2 fields and Insert summary in the appropriate group footers):

@Subgroup_fld1_row_total

//Assuming that there are only two categories

//you can simply take a sum of FLD1, which will contain values

//for each category

Sum(FLD1,subgroupfield)

@Subgroup_fld2_row_total

//Assuming that there are only two categories

//you can simply take a sum of FLD2, which will contain values

//for each category

Sum(FLD2,subgroupfield)

8) Next, you'll create a row percentage similar to the following:

@Subgroup_row_percentage

If

Sum(Fld1,subgroupfield) <> 0

Then

((Sum(Fld1,subgroupfield) - Sum(Fld2,subgroupfield)) / Sum(Fld1,subgroupfield)) * 100

Else

0

9) You'll need to repeat these steps to create summaries at the primary group level and at the Grand Total Level

~Kurt

1) Create groups as you have

2) Create Column Labels

3) Create formulas that will be placed in the detail section of the report. These formulas will be something like:

@Cat1_Fld1

If

Category = Cat1

Then

FLD1

Else

0

Based on your example, you'll need to create 4 formulas: Cat1_Fld1, Cat2_Fld1, Cat1_Fld2 and Cat2_Fld2. Each formula will be similar to the one shown above.

4) Right-click on each of these formulas--once they're in the detail section--and Insert Summary. You're going to Sum the values (assuming FLD2 and FLD2 have numeric values) both the subgroup and the primary group.

5) Hide or suppress the detail section.

6) Create two formulas at the subgroup level, each of which will calculate the percentage for its respective column. Each formula will look something like this:

@Cat1_subgroup_percentage

If

Sum(@Cat1_Fld1,subgroupfie

Then

((Sum(@Cat1_Fld1,subgroupf

Else

0

7) Next you'll create formulas for the Row totals at the subgroup level. The row totals formulas will look like this (alternate, you can just right-click on the Fld1 and Fld2 fields and Insert summary in the appropriate group footers):

@Subgroup_fld1_row_total

//Assuming that there are only two categories

//you can simply take a sum of FLD1, which will contain values

//for each category

Sum(FLD1,subgroupfield)

@Subgroup_fld2_row_total

//Assuming that there are only two categories

//you can simply take a sum of FLD2, which will contain values

//for each category

Sum(FLD2,subgroupfield)

8) Next, you'll create a row percentage similar to the following:

@Subgroup_row_percentage

If

Sum(Fld1,subgroupfield) <> 0

Then

((Sum(Fld1,subgroupfield) - Sum(Fld2,subgroupfield)) / Sum(Fld1,subgroupfield)) * 100

Else

0

9) You'll need to repeat these steps to create summaries at the primary group level and at the Grand Total Level

~Kurt