How to create a custom group within report 2

[ewarr]

In one report (no subreports), I need to create a custom group of customers and subtotal by the custom group AND run subtotals for each individual customer with grand total at bottom. See example below. Customers C,D,E sales need to be grouped together while Cust A and B do not. Can you help? Thanks

2009 Sales


Cust A Product 1 100
Product 2 100
Product 3 100

Subtotal 300


Cust B Product 1 100
Product 2 100
Product 3 100

Subtotal 300


Custom Group

Cust C Product 1 100
Product 2 100
Cust D Product 1 100
Cust E Product 1 100
Product 2 100
Product 3 100

Subtotal Custom Group 600

Grand Total 1200

 

[Turkbear]

Hi,
What is the criteria for inclusion in a particular group?

If definable using data from the report, create a formula to do that, and group on the formula.






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ewarr]

Ok I have created a formula called "Custom 2009 Qty" as shown below that will group customers. Do I now go to group expert and add this formula as GROUP 3?

GROUP 1 = Reseller IC
GROUP 2 = Product
GROUP 3 = Custom 2009 QTY?

if {AgdataView.Reseller_IC} in
["0091653250000",
"0094581180000",
"0538106930000",
"0714125970000",
"0797894340000",
"1856442050000",
"3629459990000"]
then {AgdataView.Sales_Quantity}
else
0

 

[Turkbear]

Hi,
Yes, should work...Did you try? Tests are always better than theory.







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[scottostanek]

Use a formula to get you CustomGrouping outside of the Cust group itself.

@CustomGrouping:

if {AgdataView.Reseller_IC} in ["0091653250000","0094581180000","0538106930000","0714125970000","0797894340000","1856442050000","3629459990000"]then {AgdataView.Sales_Quantity} then "Reseller ICGROUP"
else if .... then "ProductGROUP"
else "Custom 2009 QTY"

You can suppress the Customgrouping footer (summaries line) on your report for anything not in your specials group.

Scotto the Unwise