Pivot table layout with a mixture of compact and tabular fields

[pliskers]

In a pivot table, I've got levels of geography (Region, Market, and Customer). I'd like the Region and Market in a single, compact field, but would like the Customer's Address, City, and State in successive columns to the right of the Customer name (which will remain in the first, compact field). Is this possible to do, please?

Thanks in advance!

 

[pliskers]

In a pivot table, I've got levels of geography (Region, Market, and Customer). I'd like the Region and Market in a single, compact field, but would like the Customer's Address, City, and State in successive columns to the right of the Customer name (which will remain in the first, compact field). Is this possible to do, please?

Thanks in advance!

Problem solved. I found the field setting to display the next girls in tabular format.