I can't "PF" to get part of "D" result

[Former Member]

I have question.

I can use Group to handle. but that sum of total (GROUP) I not understand that result to PF

I attach image,

you can see

GROUP1 $17.00

GROUP2 $1010.00

GROUP3 $3.00

I need "PF" to show that result

sum of grp1: $17.00

sum of grp2: $1010.00

sum of grp3: $3.00

sum of grp1+2 = $1027.00

sum of grp2+3 = $1013.00

sum of ALL (grp1+2+3) = $1030.00

any advice how to beign.

pleae!

[abhilash_kumar]

HI fkii,

How many pages can this report span?

What happens to the totals on the Page Footer when the report spans multiple pages?

P.S: Remember that the PF displays on each page!

-Abhilash

[Former Member]

As per your requirement

Create a formula like

@PageFooterGroup

shared numbervar agroup1;

shared numbervar bgroup2;

shared numbervar cgroup3;

if GroupName ({groupElement})= 'groupNam1' then agroup1:=Sum ({groupMeasure}, {groupElement});

if GroupName ({groupElement})= 'groupNam2' then bgroup2:=Sum ({groupMeasure}, {groupElement});

if GroupName ({groupElement})= 'groupNam3' then cgroup3:=Sum ({groupMeasure}, {groupElement});

then create 3 more formula like

@pfg1

shared numbervar agroup1;

@pfg2

shared numbervar bgroup2;

@pfg3

shared numbervar cgroup3;

then create another 3 formula like

@pfg1+pfg2

shared numbervar agroup1;

shared numbervar bgroup2;

agroup1+bgroup2;

@pfg2+pfg3

shared numbervar bgroup2;

shared numbervar cgroup3;

bgroup2+cgroup3

@pfg1+pfg2+pfg3

shared numbervar agroup1;

shared numbervar bgroup2;

shared numbervar cgroup3;

agroup1+bgroup2+cgroup3;

in page footer use like this

sum of grp1:$@pfg1

sum of grp2:$@pfg2

sum of grp3:$@pfg3

sum of grp1+2 =$@pfg1+pfg2

sum of grp2+3 =$@pfg2+pfg3

sum of ALL (grp1+2+3) =$@pfg1+pfg2+pfg3