Silly pivot table question

[samilynn]

Sorry if this is very basic, but I can't figure it out:

In a Pivot Table, I am trying to display the Mfg Number and Mfg Name next to each other, then the sales for multiple years in the pivot.

However, the only way I can get it to display is the Mfg Number and the Name in different rows (Name right below the Number), not on the same row.

Maybe it's too early in the morning for me, but is there a trick I'm missing?

thank you!!

Sammy

 

[RoryA]

It sounds like you probably just need to alter the report layout on the pivot table tools design tab to Tabular layout.

 

[samilynn]

It sounds like you probably just need to alter the report layout on the pivot table tools design tab to Tabular layout.

Thank you!!!!!