Formatting cross tab

[khekking]

Is there a way to insert a blank row in a cross tab following summary data? For example, I have a manual cross tab that details sales for the last five fiscal years for all customers. After the total column I want to insert a blank row for easier readability.

(I currently display)

XX000 FY2001 FY2002 FY2003 FY2004 FY2005 etc
Cat#1 $500 $500 $500 $500 $500
Cat#2 $500 $500 $500 $500 $500
Cat#3 $500 $500 $500 $500 $500
Cat#4 $500 $500 $500 $500 $500
TOTAL $2000 $2000 $2000 $2000 $2000
XX001 FY2001 FY2002 FY2003 FY2004 FY2005 etc
Cat#1 $500 $500 $500 $500 $500
Cat#2 $500 $500 $500 $500 $500
Cat#3 $500 $500 $500 $500 $500
Cat#4 $500 $500 $500 $500 $500
TOTAL $2000 $2000 $2000 $2000 $2000

Where I want to display

XX000 FY2001 FY2002 FY2003 FY2004 FY2005 etc
Cat#1 $500 $500 $500 $500 $500
Cat#2 $500 $500 $500 $500 $500
Cat#3 $500 $500 $500 $500 $500
Cat#4 $500 $500 $500 $500 $500
TOTAL $2000 $2000 $2000 $2000 $2000

XX001 FY2001 FY2002 FY2003 FY2004 FY2005 etc
Cat#1 $500 $500 $500 $500 $500
Cat#2 $500 $500 $500 $500 $500
Cat#3 $500 $500 $500 $500 $500
Cat#4 $500 $500 $500 $500 $500
TOTAL $2000 $2000 $2000 $2000 $2000

Thanks! Any help is appreciated.

 

[lbass]

Insert a Group Footer #1_b section.

-LB