Hi!
I have a report with one group level which gives me total of 8 groups. Now I want do add a new group which will give me (like conditional grouping?) sum below first 6 group and below last 2. Any idea?
Hi!
I have a report with one group level which gives me total of 8 groups. Now I want do add a new group which will give me (like conditional grouping?) sum below first 6 group and below last 2. Any idea?
insert Group Footer, into the report
put the sum field, =sum(field), in the group footer.
for a total footer, add an extra field in the query, like: Title: MyReport
add this Title Group as the outer most Group
put the same Sum field in its footer to get the total of all groups.
Sorry but I don't understand how I will get total for only first 6 groups?
Maybe i wasn't clear enough, Now I have 8 groups total, I want to add second group and show totals for only first 6 groups, not the last 2.
in the query, add a field using the group name of the 8.
in the say: tDepts table
Dept, Group
1, Finance
2, Finance
3, I.T.
etc
add tDepts table to the query , join on the field, add the Group
now you can sum all 8 Depts under 1 Group.