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.

You may have to enable selection -- from the Pivot toolbar, choose
PivotTable>Select, 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

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
> PivotTable>Select, 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
>
>

You may be able to create a calculated item that adds specific items in
a pivot field. (Pivot Table toolbar, PivotTable>Formulas>Calculated 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
>>PivotTable>Select, 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