I have multiple income statements that I want to combine into a pivot table.
However, when I pull the data into a pivot table, the accounts (row data) are
sorted alphabetically. Short of manually sorting the rows (all 172 of them)
every time, are there any creative ways to get the rows to align in the way
that I want them to?

I have tried to associate a "row number" with an account (i.e. Sales = 1,
COGS = 2, Gross Profit = 3) so that I can sort by the row number in the order
that I want, however, this method skews my grand totals.

Any ideas?
Thanks,
Matt