Ask Your Question

Pivot Tables Arrangement in Calc. [closed]

asked 2012-08-05 10:10:32 +0100

Steve Morris gravatar image

updated 2013-10-22 19:50:55 +0100

manj_k gravatar image

When I add multiple fields into the data area in a pivot table in calc, it arranges those fields in multiple rows in the same column. How do I get them arranged in multiple columns in the same row as excel 2002 onwards does?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 16:12:32.197775

1 Answer

Sort by » oldest newest most voted

answered 2012-08-05 11:58:46 +0100

Pedro gravatar image

You could do it as under Excel: Right click on the Pivot table, choose Layout, click on the "Data" 3D button and drag it to the right. The cursor changes from an arrow over a horizontal bar to an arrow over a vertical bar. Drop it and that's it.

However Calc does one better over Excel. You don't even have to go to the pivot table Layout. Just drag the "Data" button to the right and drop it.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2012-08-05 10:10:32 +0100

Seen: 1,485 times

Last updated: Aug 05 '12