Summary row in list report

[Starfish2201]

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

[norkos]

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