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
Hi,
You can do it as follows:
1. Group the list on the region column
2. Cilck on the Qty column body and than click on the Summarize icon on the toolbar and choose the Total element to summarize your data. After that, your list will have both the detailed and overall summary below the detailed data.
4. Next you have to move the summary elements above the detail rows. You can do it in two steps. First you have to select your list and click on the "List Header & Footer" menu item from the "Structure/Headers & Footers" menu. Check the "Overall header" and "Region (header)" elements. There will be two new rows in the list, an overall summary and a detailed summary row.
Next split both new headers to look like the same as the footer rows, unlock the list and move the summary items from the footer rows to the corresponding header rows.
6. At last delete the footer rows and your new list will be ready to use.
NoRkoS