Excel Pivot Table - 2 Reports With Same Page Fields

P

PCD

Is it possible to have 1 list of Page Fields yet display two sets of
data, either on the same sheet or separate.

Example

Page field is Order Status with possible values of:
OPEN
PROCESSING
SHIPPED
PAID

One Pivot Report would show columns like
Order Date, Customer Name, Shipper

and the other report might have columns
Amount, Product, Payment Method

When you change the Order Status page field, both reports change.

Thanks
 
Top