Ask Your Question
0

Any way for Pivot table in columns instead of rows? [closed]

asked 2013-10-25 10:21:41 +0200

Rags gravatar image

Hi,

I am getting pivot table result in rows but i wanted the results to be shown in column please suggest.

Please give me pivot table using below data in column format:

Employee Code Basic HRA Travel Allowance Bonus G1 4000 2000 500 800 G2 4000 2000 500 800 G3 4000 2000 500 800 G4 3000 1500 500 800 G5 3000 1500 500 800 G6 3000 1500 700 0 G7 3000 1500 700 1000 G8 3000 1500 700 1000 G9 6000 3000 700 1000 G10 6000 3000 700 1000 G11 6000 3000 700 1500 G12 6000 3000 800 1500 G13 11000 5500 800 1500 G14 11000 5500 800 1500 G15 11000 5500 800 1500

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-12 13:05:49.741014

1 Answer

Sort by » oldest newest most voted
0

answered 2013-10-25 12:00:48 +0200

m.a.riosv gravatar image

Have you tried putting the fields as Column Fields?
Also it is possible drag the fields from RowFields<->ColumnFields editing PT or directly in the sheet dragging the FieldTitle. And combine some in Rows and some in Columns.

image description

Please take a look at the documentation. LibreOffice_Calc_Guide - Chapter 8 Using Pivot Tables.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-10-25 10:21:41 +0200

Seen: 1,064 times

Last updated: Oct 25 '13