Re: Pivot Tables: Pivot table layout
The problem with your sample file A3 was the way you defined the dynamiv range. Your data actually start in cell A5, so the DNR needs to begin there. The number of rows in the dataarea must be calculated not counting the entries in column A above A5. So, the DNR should be dfined as (there is more than one way to to get the same result, but start with this one.)
=OFFSET(Sheet1!$A$5,0,0,COUNTA(Sheet1!$A:$A)-3,11)
Once you get this definition correct, the other symptoms you described should vanish.