| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot Table Subtotals
Hi, I have been using pivot tables and suddenly the arrow (cursor) that we
get to select specific colums is not to been seen. It just shows the normal + cursor on the page and i am unable to select specific rows globally. Please also help me in getting the subtotal of specific rows that i want. Its shows the subtotal but without any figure on it. Can any one please help me out. Thanks a lot and have a nice week ahead. Regards.. siyer. |
|
#2
|
|||
|
|||
|
You may have to enable selection -- from the Pivot toolbar, choose
PivotTableSelect, and click on Enable Selection Siyer wrote: Hi, I have been using pivot tables and suddenly the arrow (cursor) that we get to select specific colums is not to been seen. It just shows the normal + cursor on the page and i am unable to select specific rows globally. Please also help me in getting the subtotal of specific rows that i want. Its shows the subtotal but without any figure on it. Can any one please help me out. Thanks a lot and have a nice week ahead. Regards.. siyer. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
Thanks indeed for your help. I have one more question, is it possible to sum
specific rows in Pivots? "Debra Dalgleish" wrote: You may have to enable selection -- from the Pivot toolbar, choose PivotTableSelect, and click on Enable Selection Siyer wrote: Hi, I have been using pivot tables and suddenly the arrow (cursor) that we get to select specific colums is not to been seen. It just shows the normal + cursor on the page and i am unable to select specific rows globally. Please also help me in getting the subtotal of specific rows that i want. Its shows the subtotal but without any figure on it. Can any one please help me out. Thanks a lot and have a nice week ahead. Regards.. siyer. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#4
|
|||
|
|||
|
You may be able to create a calculated item that adds specific items in
a pivot field. (Pivot Table toolbar, PivotTableFormulasCalculated Item) Siyer wrote: Thanks indeed for your help. I have one more question, is it possible to sum specific rows in Pivots? "Debra Dalgleish" wrote: You may have to enable selection -- from the Pivot toolbar, choose PivotTableSelect, and click on Enable Selection Siyer wrote: Hi, I have been using pivot tables and suddenly the arrow (cursor) that we get to select specific colums is not to been seen. It just shows the normal + cursor on the page and i am unable to select specific rows globally. Please also help me in getting the subtotal of specific rows that i want. Its shows the subtotal but without any figure on it. Can any one please help me out. Thanks a lot and have a nice week ahead. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table not showing subtotals | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
| pivot table row subtotals | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| Pivot Table subtotals | Excel Worksheet Functions | |||
Linear Mode
