I am quite lost and welcome some logical explanation. This is what I have done.

Click http://www.contextures.com/xlPivot07.html and download the tiny sample file.

Select the SalesPivot sheet (the one one screen when the file is opened). Drag all the fields including page field away from the PT until the only thing left is the outline. Now, drag units from the field list to the row area. (Note: I won't do this for real life; I just do this for this experiment. Bear with me and hear me out.) Then drag the same units field to the data area. Copy both columns to column G and H respectively. Sort column G in ascending order and do AutoSum. I have got 805 as total. I do the same for column H - sort in ascending order and AutoSum. I have got 1208 which is identical to the grand total in the PivotTable. I am missing 403 units from column G. Where have they gone? You will note that the largest number in column H is 196 but it is nowhere to be found in column G. Where has it gone?

Does anyone have an explanation? Roger, do you still want to bet with me? <bg

Epinn