| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Subtotals
Please assist
I have been unsuccessfully trying to figure out a way to get the column totals for every change in service type. Below is sample of the pivot table service type 1-2 days 3-9 days 10-30 days 30+ st1 12 8 3 4 st1 3 4 5 4 st1 TOTAL st2 5 7 9 3 st2 6 4 11 2 st2 total Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Subtotals
did you try to select "service type" (any item or the heading) right click,
select field setting and in the pop up windows select custom and the kind of subtotal you like? "Gwen" wrote: Please assist I have been unsuccessfully trying to figure out a way to get the column totals for every change in service type. Below is sample of the pivot table service type 1-2 days 3-9 days 10-30 days 30+ st1 12 8 3 4 st1 3 4 5 4 st1 TOTAL st2 5 7 9 3 st2 6 4 11 2 st2 total Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Subtotals
"Andrea" wrote: did you try to select "service type" (any item or the heading) right click, select field setting and in the pop up windows select custom and the kind of subtotal you like? "Gwen" wrote: Please assist I have been unsuccessfully trying to figure out a way to get the column totals for every change in service type. Below is sample of the pivot table service type 1-2 days 3-9 days 10-30 days 30+ st1 12 8 3 4 st1 3 4 5 4 st1 TOTAL st2 5 7 9 3 st2 6 4 11 2 st2 total Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Subtotals
Yes, I did and put a row count for each service type in a total column next
to the 30+ column. Thanks "Andrea" wrote: did you try to select "service type" (any item or the heading) right click, select field setting and in the pop up windows select custom and the kind of subtotal you like? "Gwen" wrote: Please assist I have been unsuccessfully trying to figure out a way to get the column totals for every change in service type. Below is sample of the pivot table service type 1-2 days 3-9 days 10-30 days 30+ st1 12 8 3 4 st1 3 4 5 4 st1 TOTAL st2 5 7 9 3 st2 6 4 11 2 st2 total Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Subtotals
How is the pivot table set up? What fields are in the Row area, the
Column area, and the Data area? What version of Excel are you using? Gwen wrote: Please assist I have been unsuccessfully trying to figure out a way to get the column totals for every change in service type. Below is sample of the pivot table service type 1-2 days 3-9 days 10-30 days 30+ st1 12 8 3 4 st1 3 4 5 4 st1 TOTAL st2 5 7 9 3 st2 6 4 11 2 st2 total Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Subtotals
how come you have two st1 in a pivot table? are you sure they are typed
exactly the same in the source data? Or you have one more row field not shown in the example? "Gwen" wrote: Yes, I did and put a row count for each service type in a total column next to the 30+ column. Thanks "Andrea" wrote: did you try to select "service type" (any item or the heading) right click, select field setting and in the pop up windows select custom and the kind of subtotal you like? "Gwen" wrote: Please assist I have been unsuccessfully trying to figure out a way to get the column totals for every change in service type. Below is sample of the pivot table service type 1-2 days 3-9 days 10-30 days 30+ st1 12 8 3 4 st1 3 4 5 4 st1 TOTAL st2 5 7 9 3 st2 6 4 11 2 st2 total Thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Subtotals
Thanks for responding.
Row Area: service type 1-2 days 3-9 days 10-30 days 30+ Column Area: Nothing Data Area: Count of service area The data is an Access crosstab query export "Debra Dalgleish" wrote: How is the pivot table set up? What fields are in the Row area, the Column area, and the Data area? What version of Excel are you using? Gwen wrote: Please assist I have been unsuccessfully trying to figure out a way to get the column totals for every change in service type. Below is sample of the pivot table service type 1-2 days 3-9 days 10-30 days 30+ st1 12 8 3 4 st1 3 4 5 4 st1 TOTAL st2 5 7 9 3 st2 6 4 11 2 st2 total Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Subtotals
You may need to reorganize the data, so you can use it in a pivot table.
You can use the 'unpivot' technique described by John Walkenbach: http://j-walk.com/ss/excel/usertips/tip068.htm Assuming the crosstab export looks like this: service type 1-2 days 3-9 days 10-30 days 30+ st1 12 8 3 4 st1 3 4 5 4 st2 5 7 9 3 st2 6 4 11 2 Using the unpivot technique will create this layout: Service Type Length Count st1 1-2 days 12 st1 3-9 days 8 st1 10-30 days 3 And you can create the pivot table from that. Gwen wrote: Thanks for responding. Row Area: service type 1-2 days 3-9 days 10-30 days 30+ Column Area: Nothing Data Area: Count of service area The data is an Access crosstab query export "Debra Dalgleish" wrote: How is the pivot table set up? What fields are in the Row area, the Column area, and the Data area? What version of Excel are you using? Gwen wrote: Please assist I have been unsuccessfully trying to figure out a way to get the column totals for every change in service type. Below is sample of the pivot table service type 1-2 days 3-9 days 10-30 days 30+ st1 12 8 3 4 st1 3 4 5 4 st1 TOTAL st2 5 7 9 3 st2 6 4 11 2 st2 total Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Subtotals
Many Thanks
"Debra Dalgleish" wrote: You may need to reorganize the data, so you can use it in a pivot table. You can use the 'unpivot' technique described by John Walkenbach: http://j-walk.com/ss/excel/usertips/tip068.htm Assuming the crosstab export looks like this: service type 1-2 days 3-9 days 10-30 days 30+ st1 12 8 3 4 st1 3 4 5 4 st2 5 7 9 3 st2 6 4 11 2 Using the unpivot technique will create this layout: Service Type Length Count st1 1-2 days 12 st1 3-9 days 8 st1 10-30 days 3 And you can create the pivot table from that. Gwen wrote: Thanks for responding. Row Area: service type 1-2 days 3-9 days 10-30 days 30+ Column Area: Nothing Data Area: Count of service area The data is an Access crosstab query export "Debra Dalgleish" wrote: How is the pivot table set up? What fields are in the Row area, the Column area, and the Data area? What version of Excel are you using? Gwen wrote: Please assist I have been unsuccessfully trying to figure out a way to get the column totals for every change in service type. Below is sample of the pivot table service type 1-2 days 3-9 days 10-30 days 30+ st1 12 8 3 4 st1 3 4 5 4 st1 TOTAL st2 5 7 9 3 st2 6 4 11 2 st2 total Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Subtotals | Excel Discussion (Misc queries) | |||
| Subtotals in a Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Subtotals | Excel Discussion (Misc queries) | |||
| Pivot Table subtotals | Excel Worksheet Functions | |||
| Pivot table subtotals 100% | Excel Discussion (Misc queries) | |||
Linear Mode
