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!
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!