Charting

[jjenright]

I have one group showing using a formula for comany groups. For example (if company # in 1 to 10 then group = 1, if company # in 11 -20 then group = 2, etc.) I use a running total for each group to get total dollars for that group. I then total the running total for each group into a grand total using a running total. I have the grand total in the report footer. I would like to pie chart each company group to the grand total for all company groups. For example, group 1 total = $1000, group 2 total = $2000, group 1 through 7 (I have 7 groups) grand total = $10,000. I would like to show $1,000 and $10,000 in one chart and then $2,000 and $10,000 in the next chart etc. I need to show a chart for each company group as it relates to the total for all company groups. Any assistance would be greatly appreciated.

 

[lbass]

Try changing your formulas so that only one group is compared with all others except that group:

if {table.companyID} in 11 to 20 then {#grp2rt} else {#allrt} - {#grp2rt}

-LB