Pivot Table Subtotals

S

Siyer

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.
 
D

Debra Dalgleish

You may have to enable selection -- from the Pivot toolbar, choose
PivotTable>Select, and click on Enable Selection
 
S

Siyer

Thanks indeed for your help. I have one more question, is it possible to sum
specific rows in Pivots?
 
D

Debra Dalgleish

You may be able to create a calculated item that adds specific items in
a pivot field. (Pivot Table toolbar, PivotTable>Formulas>Calculated Item)
 
Top