Why am i not getting grand total per row in pivot

[bossclaus]

Hi

My Pivot is driving my creasy, I get a grand total per colom but not per row, I have added, I have tryed changing the raw data so everting is number

what am i missing?

Claus

 

[Yahya]

you can activate it
from PivotTable Tools --> Design --> Grand Totals --> On For Rows and Columns

 

[bossclaus]

I have tryed all 4 possiblities. i canse the grand total per colum comes and go's but the rows don't do any thing.!!

 

[Yahya]

claus
in value area, do you have one fileld??

 

[bossclaus]

No i have 12 month data and i want to have total per item number I have the total per month goin down.

I can make a manuel sum on the side but then i have to change every time adding change

 

[R Pelle]

Depending on the type of your data that may well be how Excel behaves
If e.g. you data is as follows
<CODE>
Sold
Items Jan Feb etc
A 12 14 5
B 10 22 36
C 100 99 75
</CODE>
and you create a pivot table it will only Grand total the columns.
(items in row, month in col)

To fix that add a totals column (=sum jan-dec) to your data and then include the total col it in your pivot range.

If your data is e.g.
<CODE>
Name Dept Country
Joe HR MY
Jane RE NL
Bill FN UK
</CODE>
and you create a pivot to sum names by Dept (row) country (col) the pivot will give you a Row Total (and a col total).
Apologies for crappy code, I cant install HTML add-in in office.