Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal based on a range of data in Pivot Table
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal based on a range of data in Pivot Table
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 "HenrikH" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal based on a range of data in Pivot Table
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal based on a range of data in Pivot Table
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 ? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal based on a range of data in Pivot Table
Excel 2007 Pivot Table
Add an auxiliary column to the OLAP PT, then proceed as before. http://www.mediafire.com/file/50xzm4...09_24_09a.xlsx |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal based on a range of data in Pivot Table
On 25 Sep., 03:51, Herbert Seidenberg wrote:
Excel 2007 Pivot Table Add an auxiliary column to the OLAP PT, then proceed as before.http://www.mediafire.com/file/50xzm4...09_24_09a.xlsx Sorry, but I'm using Excel 2003 so.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal pivot table data to show % split | Excel Discussion (Misc queries) | |||
Exclude data from Pivot Table based on filter? | Excel Discussion (Misc queries) | |||
Pivot Tables with different groupings based on same data table | New Users to Excel | |||
Pivot Table: showing data as % of subtotal | Excel Discussion (Misc queries) | |||
display data as a percentage of a subtotal in excel pivot table | Excel Discussion (Misc queries) |