Hi

Here is an inelegant way:

Add another column to your data sourse. In that column enter 1,2,...
Add this field as the first field in the row area. Double-click its field
button and set subtotals to None. Highlight all the cells in the new column
including its button and choose Format, Cells, Number tab, Custom and on the
type row enter ;;;
if you can stand not seeing the Sum of Sales button you can hide the column
and/or its row.

If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Apprentice" wrote:

Pivot
Employee Quarter Sales
A 1 100
2 115
3 120
4 105
B 1 150
2 120
Format needed
Employee Quarter Sales
A 1 100
A 2 115
A 3 120
A 4 105
B 1 150
B 2 120