akephart
New member
Is there any way to sort by a Row Label and hide it? I need to create a pivot that looks like a financial statement. I am using the Outline and subtotals below format. I want to be able to force the order of my Revenue and Expense categories. I thought if I created a Column with the sort order that it would work and it does but I don't want to display it. Is there some other trick to force this type of format?
Revenue
- General
- Advertising
- Subscriptions
Expenses
- Wages & Benefits
- Direct Costs
- Other Expenses
Revenue
- General
- Advertising
- Subscriptions
Expenses
- Wages & Benefits
- Direct Costs
- Other Expenses