ExcelBanter - Multiple Fields In Multiple Ranged Pivot Table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Multiple Fields In Multiple Ranged Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/158831-multiple-fields-multiple-ranged-pivot-table.html)

FARAZ QURESHI

Multiple Fields In Multiple Ranged Pivot Table

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

All times are GMT +1. The time now is 01:59 AM.