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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column Heading on each row in pivot table 1
Pivot Table - Compare Dates & calc. % 1
Calculated Item causes undue repitition in pivot table 2
Pivot Table Set Up 2
Pivot table, IF function, calculated item versus calculated field 1
Custom Formula in Pivot Table Row 4
Grand Total for Rows not Working in a Pivot Table 1
Month calculation from cost for a business plan - please help 3

Back
Top