Ask Your Question

How to sort pivot table by data

asked 2013-06-16 21:18:11 +0200

adamf gravatar image

updated 2013-10-22 19:21:59 +0200

manj_k gravatar image

I want to sort my pivot table by one of the data columns, but I can't figure out how to do it. Is it possible?

edit retag flag offensive close merge delete


L-user, I think your answer is what I was looking for. However, when I click the arrow next to "data" label nothing happens. I guess a menu should appear like it does for my column header. Perhaps a bug?

adamf gravatar imageadamf ( 2013-06-27 16:04:37 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2013-06-16 22:56:39 +0200

David gravatar image

I'm not a very knowledgeable Calc user, but this will work:

  • copy your pivot table
  • paste in a new sheet
  • select the column you want to sort on
  • click Data > Sort, and choose the "Extend Selection" option
  • choose sort options > Sort!

Works for me. There might be a faster way, but at least this keeps the original pivot table intact, too.

edit flag offensive delete link more


This is sadly the only way to do this in version Sorts prior to 6 seemed to sort on the first defined row or column field but no longer do in

JD4x4 gravatar imageJD4x4 ( 2018-05-24 20:44:39 +0200 )edit

Pivot table data can still be sorted in LO6. Edit the pivot table layout, then double-click on the first Row Field. This brings up a dialog that contains the Options button mentioned in @m.a.riosv's answer.

Jim K gravatar imageJim K ( 2018-06-24 08:53:30 +0200 )edit

@Jim K thank you for your comment! I think this is the best answer (it helped me), you definitely should post it as an answer, not just a comment! Especially for those who came here from search engines, like I did.

librelive gravatar imagelibrelive ( 2019-09-29 13:00:34 +0200 )edit

answered 2013-06-17 09:00:55 +0200

L-user gravatar image

Inside pivot table column header there is drop-down list. Click on drop-list's arrow and select "Sort Ascending" or "Sort Descending".

Also consider the order of columns/rows. Move column/row to the first position and then sort.

edit flag offensive delete link more

answered 2013-06-16 22:54:12 +0200

m.a.riosv gravatar image

Drag the column by their title to the beginning of the columns position.

I you want sort by calculated field, edit the PT, right click on row/column field and in Options - Sort by you can select the calculated field.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2013-06-16 21:18:11 +0200

Seen: 8,674 times

Last updated: Jun 17 '13