Export Crosstab Reports to Excel
I created a crosstab reports of my division's Staff Hours per period per year which prints to one page in PDF. When I "save to Excel" I get all 4,000 individual records and no summary fields. I tried using File> Export and Group by Fiscal Year (my sort field). Then I get the sum for all fiscal years aka 500 instead of FY04 80, FY05 120, FY06 100, etc.
Any ideas would be very helpful. Thanks