CODEWITHSUNDEEP
excel
Chadi N
Chadi N

Reputation: 441

My pivot table didn't respected the order of my groups

I have 15 employees working on different projects right now. I took all the reception dates of the projects and checked the delay between todays date and the reception dates. it goes from 14 days to about 900 days. I created a pivot table, where I can see every employe and the delays of each projects in a horizontal bar table.

I Separated the groups like this : (0-60 days) (61-90) (91-150) (151-210) (211-365) (365+)

I used VLOOKUP for the groups.

The problem is, when I created my pivot table, the groups got all messed up and they are not in order anymore.

example : (0-60) (151-210) etc...

Any help is greatly appreciated

Here is a screenshot of my problem : https://pasteboard.co/IpNhm1c.png

Upvotes: 0

Views: 175

Answers (1)

Mark S.
Mark S.

Reputation: 2596

  1. Click the Column Header in the Pivot Table
  2. While selected, you will see a thick border around the cell(s)
  3. Click and hold the border and you will see a thick line similar to an I, this means you can drag this left or right and you can drop the header in whichever order you'd like. (I would start by moving the 366+ to the right side)

Upvotes: 1

Related Questions