Subtotal based on a range of data in Pivot Table

H

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
 
A

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
 
H

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 ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Pivot Table Help PLEASE 1
Subtotal percents in pivot table 1
Subtotal 2
Need help creating a running subtotal 2
% of subtotal in pivot table 1
Subtotals in a Pivot Table 1
adding more data to pivot table. 3

Top