I have a pivot table with a line of journalnumbers in the rows and
some persons in th coloumns.

I want a subtotal for the journals - not per journal (as the subtotal
usally is in the pivot) but for at range of journalnumbers. And i also
want the subtols to be shown not the journalnumbers.

Eks:

J.no. Bert Bill Kim
102 5 4 3
104 7 5 5
118 6 3 5
124 5 4 3


What I want - ie subtotal for the journalnumbers in the range
100-110, 111-120 og
121-130 :


Range 1 12 9 8
Range 2 6 3 5
Range 3 5 4 3


Can this be done in the Pivot Table?

I'm using Excel 2003

HenrikH