Is there a way to sort a pivot table by two fields? I have a field with
Fiscal year and a field with Gross margin %. I want the pivot table sorted
by the total gross margin % for the salesman but I do not want FY 2006 to be
above FY 2005. By using a Sort by Gross Margin % it is sorting by the Fiscal
Year subtotals and not just the total.