Multiple Range Pivot Table (Urgent Please)

F

FARAZ QURESHI

I have 3 Sheets with same following headings in columns A to E, for 3
different products (X, Y, Z):

Case Branch City Segment Amount Qty

I want a consolidated Pivot Table as follows:

Page Field: (Products: X, Y, Z)

Columns: 1. Segment

Rows: Data:
1. Branch 1. Sum of Amount
2. City 2. Sum of Quantity

All your help is highly appreciated & obliged. It is once again requested
that urgent assistance may kindly be provided.

Best Regards!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Fields In Multiple Ranged Pivot Table 0
PIVOT TABLE RELOCATING A SUB FIELD 0
RELOCATING A FIELD IN A PIVOT TABLE 0
Ungrouping the fields inside pivot table(Excel 2007) 1
Pivot Table - Row Label Combination 0
How do I create a calculated field on the Total in a pivot table? 0
transpose rows to column (cell) 3
Creating Pivot Table with Macro using Multiple Sheets 0

Top