Pivot table data in column format

arkath

New member
Joined
Nov 28, 2013
Messages
2
Reaction score
0
Points
0
Hi everyone, I am new in this forum and need your expert advise about pivot table. I need the pivot table data row by row format, means I have 3 columns 1. Supplier Name, Purchase Order and Amount, when I create the pivot table and dragging the fields the purchase order data appear below supplier Name. I would appreciate if anybody can advise me how to move the purchase order field in column B to get the data row by row. thanks in advance best regards
 
Click somewhere in the pivot table then on the Design Tab of the PivotTable Tools group on the right side of the Ribbon, click the Report Layout dropdown and choose 'Show in Tabular Form'.
 
Many thanks dear, it's resolved now, best regards,
 
Back
Top