Order Data in Pivot Table Non ascending or Decending

  • Thread starter Thread starter cailotto
  • Start date Start date
C

cailotto

I've had problems ordering my data in a pivot table. How do I order
the data to be formatted the way I want it to be?

e.g
Want:
Year 1 Year 2 Year 3
Sales 1000 1250 1500
Less: Cost of Goods Sold 500 450 500
Gross Profit 500 800 1000
Selling Expenses 200 400 600

Instead of:
Gross Profit 500 800 1000
Less: Cost of Goods Sold 500 450 500
Sales 1000 1250 1500
Selling Expenses 200 400 600
 
cailotto,

Select the cell, then click the border and drag the cell to the position
where you want the label.

HTH,
Bernie
MS Excel MVP
 
Back
Top