Microsoft Excel Office 365 Pivot table format

Hello expert,

Working on a pivot table in Excel.
Need to make Allens (my)  pivot table the same as Chris pivot table.
Chris file Allens_report_b.jpg
In Chris file the PAYER_NAME, PAYER_ID, PRICING_RULE, COMPONENT_NAME, et.al
are columns with the values listed under the field or column name.

In Allen file the values are indented and the column names do not appear.

How can I get the Column Names to appear with values underneath as shown is Chris file.?
If unable to tell deductively the Allen file attached herewith.

Thanks.

Allen in Dallas
PayerContractPricingAudit-v05-20180.xlsx
Allen PittsBusiness analystAsked:
Who is Participating?
 
NorieVBA ExpertCommented:
Add PAYER_ID, PAYER_NAME etc as Row Items and set the Report Layout as Show in Tabular Form.
0
 
Allen PittsBusiness analystAuthor Commented:
That works. Thanks.
0
 
Allen PittsBusiness analystAuthor Commented:
That works. Thanks.
0
 
NorieVBA ExpertCommented:
Allen

No problem, sorry for not going into more detail.

It actually took me quite a while to figure out the correct settings/layout etc thanks to all the new options etc available for pivots.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.