pivot tables and row totals

  • Thread starter Thread starter James Gilbert
  • Start date Start date
J

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
_______________________________________________________________
 
Back
Top