Any way for Pivot table in columns instead of rows?

[Rags]

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

[mariosv]

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.

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