2 missing lines in the earlier steps,
re-instated, it should read as:
Assume your col headers in A1:C1 a Cust, Prod, Rev
Select any cell within the table, click Data Pivot Table ..
Click Next Next. In step 3 of the wiz., click Layout
Drag n drop Cust in ROW area
Double-click on it, set SubTotals to None OK
Drag n drop Prod in ROW area (below Cust)
Drag n drop Rev in DATA area (it'll appear as Sum of Rev)
Click OK Finish
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik
---