Report Footer summary

[kevivnajar]

Hi,

I currently have a report which is as below:

APAC
A 50
B 60
C 30
EMEA
A 40
B 50
C 30
JAPAN
A 10
B 30
C 50

Now, I need a footer to calculate and show the Grand total as follows:

Worldwide
A (total of A for all regions) - 100
B (total of B for all regions) - 140
C (total of C for all regions) - 110

Normally the grand total gives the total (here, 350) and doesn't break up A,B & C.

Is there a way I can break up the grandtotal ?


Thanks,

Keviv Najar

[MMcCarthy]

Assumptions:
As you haven't given any fieldnames I've used FieldName for the ABC field and Total for the number field.

For A

=Sum(IIf([FieldName]="A",[Total],0))

For B

 =Sum(IIf([FieldName]="B",[Total],0))

For C

 =Sum(IIf([FieldName]="C",[Total],0))

Mary