Starfish2201
Programmer
Hi,
I have a list report for which I need to show data for certain group (like region)
E.g.
Item Region State Qty
----- ------- ------ ---
Item1 Midwest Illinois 10
Wisconsin 2
Indiana 5
Northeast NJ 5
NYC 2
DE 3
Now I am able to show this on list report. But I want 2 summary level rows on TOP of the table(right after column headers) which is Region level and Nation Level and would want the below format.
Item Region State Qty
----- ------- ------ ---
Nation Total 27
Item1 Midwest 17
Illinois 10
Wisconsin 2
Indiana 5
Northeast 10
NJ 5
NYC 2
DE 3
Can you please show some pointers?
Really appreciating your help !
Thanks,
I have a list report for which I need to show data for certain group (like region)
E.g.
Item Region State Qty
----- ------- ------ ---
Item1 Midwest Illinois 10
Wisconsin 2
Indiana 5
Northeast NJ 5
NYC 2
DE 3
Now I am able to show this on list report. But I want 2 summary level rows on TOP of the table(right after column headers) which is Region level and Nation Level and would want the below format.
Item Region State Qty
----- ------- ------ ---
Nation Total 27
Item1 Midwest 17
Illinois 10
Wisconsin 2
Indiana 5
Northeast 10
NJ 5
NYC 2
DE 3
Can you please show some pointers?
Really appreciating your help !
Thanks,