Subtotal based on a range of data in Pivot Table

[HenrikH]

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

 

[Ashish Mathur]

Hi,

I do not think this can be done in a pivot - for the following 2 reasons:

1. Your ranges are not consistent I.e. there are 11 nos in Group 1 and 10
in Group 2. One can group in a pivot but for that the all ranges must have
the same difference;
2. In the pivot, the output (after grouping) can be 100-110, 111-120 etc.,
you cannot have text values such as Range1, Range2 etc.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Herbert Seidenberg]

Excel 2007 Pivot Table
Odd grouping and text values easily done.
http://www.mediafire.com/file/jzunxyudviw/09_24_09.xlsx
Excel 2003 aid included.

 

[HenrikH]

Hi Herbert.
Thanks for the Xls-file.

However I do not have the data in the Excel Workbook but derive them
from a SQL database.

Therefore I cannot work on the date before the are used in the Pivot
table - or can I ?

 

[Herbert Seidenberg]

Excel 2007 Pivot Table
Add an auxiliary column to the OLAP PT,
then proceed as before.
http://www.mediafire.com/file/50xzm4rvjew/09_24_09a.xlsx

 

[HenrikH]

Excel 2007 Pivot Table
Add an auxiliary column to the OLAP PT,
then proceed as before.http://www.mediafire.com/file/50xzm4rvjew/09_24_09a.xlsx

Sorry, but I'm using Excel 2003 so....