pivot tables and row totals

[James Gilbert]

Now Frank has kindly cleared up my listing unique values problem,

I now need to get rid of the sub-totals from my pivot table. Is that
possible? Here's a sample:

1 g 0 0 1 0 0
1 Total 0 0 1 0 0
2 g 0 0 1 0 0
2 y 0 0 0 1 0
2 Total 0 0 1 1 0
3 g 0 0 1 0 1
3 Total 0 0 1 0 1

and how I would like it to look is the following

1 g 0 0 1 0 0
2 g 0 0 1 0 0
2 y 0 0 0 1 0
3 g 0 0 1 0 1

any ideas?

James

_______________________________________________________________

James Gilbert
t: (+44/0)1223 336638 m: (+44/0)7731 389380
Large Animal Research Group *small animal division*
Dept. Zoology, Cambridge University, Cambridge CB2 3EJ
_______________________________________________________________

 

[Debra Dalgleish]

Double-click on the Row field button
Under Subtotals, choose None
Click OK

 

[James Gilbert]

Many, many thanks indeed. I'd never have found that !

James