How do I combine group totals and display total values 1

[micheleg]

I have a gross profit report sorted by product line (which I have created as groups. I need to combine the totals of some of the product lines into one line.
Current setup
product line gp
0033 33%
0034 36%
0035 30%

Required result
Paper 32%

Any suggestions......

 

[lbass]

To create a higher order group, you can create a formula like:

if {table.prodline} in ["0033" to "0035"] then "Paper" else
if {table.prodline} in ["0036","0038"] then "Scissors" else "Rock"

You would insert a group on this formula and then go to report->change group expert->use the direction key to make it your highest level group (Or you can drag it to the highest level position by clicking on the gray area to the left of the canvas while in design mode).

Depending on what your summary is, you might be able to simply right click on a detail field and choose "insert summary"->"insert summary for all groups". If the summary is more complex, you need to share the contents of the formula you are using for the summary.

-LB