Multiple Fields In Multiple Ranged Pivot Table

F

FARAZ QURESHI

Can one devise a pivot table based upon two sheets (for two different
companies) with similar following columns:
Branch Product Amount Qty

as follows, instead of simply Rows & Columns?
<PIVOT TABLE>
Amount Qty
Branch-A Product-1
Product-2
Product-3

All Modes & Codes shall be highly obliged.

Thanx & 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 Range Pivot Table (Urgent Please) 0
RELOCATING A FIELD IN A PIVOT TABLE 0
PIVOT TABLE RELOCATING A SUB FIELD 0
Creating Pivot Table with Macro using Multiple Sheets 0
CUSTOM FIELDS FOR PIVOT TABLE 0
Grand Total for Rows not Working in a Pivot Table 1
3 fields' graph 0
Manipulating pivot table fields ... 0

Top