manual sort in pivot table

Sort A-Z

Then copy and paste the specific items directly into the place where you them to be.

thanks for your reply patsy...however that will not work in pivot tables...upon further review.... and i can not find it documented anywhere... right click on desired item to move and select the move option...this is in excel 2007

thanks for your time and effort

RETNEC said:

thanks for your reply patsy...however that will not work in pivot tables...upon further review.... and i can not find it documented anywhere... right click on desired item to move and select the move option...this is in excel 2007

thanks for your time and effort

Click to expand...

I can not be very sure as I have not used Excel 2007 but I am 100% sure that copying/pasting or even typing directly in pivot tables works in Excel 2003 as long as the value you are pasting/typing is one of the items.

thanks for your time patsys...
i did answer in my previous post how to accomplish this in excel 2007...i just could not find it documented anywhere..it's done by right clicking...however you can not move a sub set if you have used outline/groups outside the parent...or move a parent by selecting an item in a subset. you can rearrange the orders within the subsets by selecting a subset item and right clicking



i did go back and try your suggestions... you can copy any in cell in a pivot table in excel 2007 however you can not paste to any cell..
or even in the formula bar...

add to previous post.... you can move any item by right clicking within the column anywhere with in the column as long as a parent item is selected

I was trying to do the same thing and rapidly becoming very frustrated with the very limited help that Excel provides. I found this post - thanks for the tip... but I also figuered out the way that MS intended for this magical drag functionality to work.

If you click on the column (or row) header that you'd like to move, the cell will be highlighted. Roll your cursor around the edge of the cell until your cursor changes into the picture of a miniture uni-directional arrow. Right-Click once and the entire column will be highlighted. Once the column is highlighted, again, roll your cursor around the edge of the highlighted column until your cursor changes into a 4-directional arrow. Right-click and hold... this will allow you to drag the entire column to a different place.

Shame on MS for such terrible help instructions!

custom column sort

q

Thankyou, thank you...thank you! Finally...I have tried to figure that drag sort in a pivot so many times.....again thank you!

Dear Sir,

I have a problem with sorting sub row items on pivot table that has one source data table.

The problem appear when I sort / drag manually a sub row items, it always moving another sub row items that has the same name.

I am a newbie in excel and I am using Microsoft excel version 2013.

I need anyone to give me some advice on this matter.

My pivot table report display as below.

Row Labels Sum of BP-Jan
NBR 6240
Aneka Komkar 2100
Indokarlo Perkasa 2100
Nagasakti Parama 2100
FA Santo 2100
Indo Dong Ah 2100
KARYA PUTRA 2100
KARYA SEKAWAN 2100
King Rubber 2100
Pongcodan Indonesia 2100
SUPER SINAR ABADI 2100
Tatakarya Rubber 2100
NBR 7030
Indokarlo Perkasa 2490
KARYA PUTRA 2490
KARYA SEKAWAN 2490
SUPER SINAR ABADI 2490
Tatakarya Rubber 2490
CATURINDO AGUNG 2490
SBR 1502
Basis Pancakarya 1720
Pentasari Pranakarya 1720
Selamat Sempana 1720
Darat 1720
Tri Duta Putra 1720
KARYA PUTRA 1720
KARYA SEKAWAN 1720
Aneka rubber Piranti 1720
Pusan Manis Mulia 1720