Hi to all,

In a pivot table how to remove the totals, that is, after each unique occurrence a sum is displayed and I only want the data to be displayed normally without any sum after each occurence.

for e.g.

Emp# Amt1 Amt2 Amt3
1234 200 300 400
total1 200 300 400
total2 200 300 400

And i want it to display like below:
Emp# Amt1 Amt2 Amt3
1234 200 300 400

thanks..