Dear

The objective of the report is to get average of each item in Retail, Wholesale, Vansale, Franchise.
Retail Order type –201,301,401,501,204,304,404,504
Vansale Order Type – 210,211,310,410,510
Wholesale – 220,221,320,321,420,421,520,521
Franchise – 202,302

I get the average of item separately for 204,304,etc order type
I get the average of order type 204,304 etc.
But I am unable to get the average separately for each item by

Retail Order type – 204,304,404,504
Vansale Order Type – 210,211,310,410,510
Wholesale – 220,221,320,321,420,421,520,521
Franchise – 202,302.

My script is attached above.

My layout is

Before.field ->tdsls045.item.1,tdsls040.cotp
Detail - >
After.field ->tdsls045.item
After.field ->tdsls040.cotp
After.report

Regards,
Suhaib

Now, the requirement have been Changed
We want only Summary of
Retail Order type - 204,304,404,504
Vansale Order Type – 210,211,310,410,510
Wholesale – 220,221,320,321,420,421,520,521
Franchise – 202,302


Regards,
Suhaib