Print a report based on a group total 1

[wgg]

Hi Guys

I have a question and would appreciate any help which you can offer.

I would like to print a report based on a group total.
For example, possible output can be as follows.

Transaction Cost
A 200
B 500
---
Group Customer1 Total 700
===
A 100
B 200
---
Group Customer2 Total 300
===
I would like to print the customers with totals greater than 500, which is Customer1. How can this be done?

Thanks.

wgg

 

[vidru]

Enter a Group Selection Formula...

Report menu > Edit Selection Formula > Group, and enter something like:
Sum({Table.Cost}, {Table.GroupField}) > 500

-dave

 

[wgg]

Thanks Dave

That worked fine.

Question: Should the grand total reflect the condition for the group as well. Because I'm still getting the grand total for all customer. eg. i'm getting a grand total of 1000 for the example given.

wgg

 

[vidru]

Try using a running total on the Cost field instead of the current grand total:

Evaluate : for each record
Reset : Never

Put it in the Report Footer, and it should give you the grand total for what's actually printed.

-dave

 

[wgg]

Thanks Dave

That solution worked perfect.

I appreciate your help greatly.

wgg

 

[vidru]

No problem, glad I could help.

-dave